Hi. There are 3 systems a customer might have: ancient, old, and new. I'm trying to write a t-sql script which will be safe to run on any of the...

Jeff Kish

05-16-2006 04:35 PM
Jeff Kish

Dear all, I'd like to explore more about indexing strategies and would appreciate a reference to some good resources this regard including book...

coosa

05-16-2006 12:05 PM
SQL

I used to be able to enter new lines into the result pane cell for text (and varchar) data in Enterprise Manager, but now that I am using SQL 2005...

AT

05-16-2006 05:03 AM
AT

Hi, I use SQL Server 2005 and VS 2005. After I create a report, I try to deploy it to Report Server, I get this error: "A connection could not made...

kai

05-15-2006 11:15 PM
kai

Hi there, Is it posible to set the collation of SQL server 2005 like Oracle, which is that objects names and column names are case-insensitive, but...

Nasir

05-15-2006 05:41 PM
Erland Sommarskog

Hi all, Am looking for some guidance/advice in terms of best practices for deploying a MS BI project. We have a relatively large BI system that we...

AT

05-15-2006 05:27 PM
AT

Can one use Truncate Table on a linked server table? When I try it, I get a message that only two prefixes are allowed. Here's what I'm...

Neil

05-15-2006 12:26 PM
Neil

I have multiple locations that I want to create views for each individual location. I am using a cursor to create the views for each location. So,...

db55

05-15-2006 12:24 PM
db55

I need to append data from a database on one server to a table in a database on a different server. Both servers are running SQL 7. How can that be...

Neil

05-15-2006 03:46 AM
Neil

Hi, I'm kind of a newbie on DB management but I have to deal with a huge DB used for real time operations. I got a temporal table where current data...

Antar

05-14-2006 12:12 PM
gulikole5

MORE THAN A THOUSAND POSITIONS NATIONWIDE Go to www.sayhi.to/JeffAltman Jeff Altman, The Big Game Hunter, is looking for people with a variety of...

Jeff

05-14-2006 08:59 AM
Jeff

Hi all, I have a string user_name and it is saved in table with single qoutes, i mean if you view the table there are single qoutes on both sides of...

Khan

05-14-2006 01:59 AM
Khan

Hi, I am using Access 2000 to access a SQL Server 2000 database. The records are read only, and I can't make any changes to them. How can I change...

JA

05-13-2006 09:16 PM
Oscar Santiesteban

NovelSpace Media, LLC has announced the launch of its new online bookstore, NovelSpace.com. Located at http://www.novelspace.com, it features a wide...

AT

05-13-2006 03:19 PM
AT

Hi to everyone, probably it's a faq but I did not find a sure answer. A customer has a Sql Server 2000 standard installed in 1server/5CAL licensing...

Pashkuale

05-13-2006 11:49 AM
Erland Sommarskog

Not a SQL guy but can do enough to be dangerous :) Trying to update a record. We have records that have a field with data surrounded by some...

geekwagon

05-12-2006 06:17 PM
Erland Sommarskog

I am using TransferSpreadsheet from an ADP file to import an Excel spreadsheet into an MSDE database. On one computer, when I run the code to import...

Jer

05-12-2006 03:32 PM
Jer

I'm using our dev ID to set up peer-to-peer replication among three SQL Server 2005 servers. The dev ID essentially has sa rights to the server and...

EoRaptor013

05-12-2006 03:28 PM
EoRaptor013

Can somebody please tell me whether the following syntax is supported or whether it's a "feature" that will someday stop working. It works in both...

Malc

05-12-2006 09:56 AM
Alexander Kuznetsov

Hello, I have two servers running SQL 2005. 1. Windows Server 2003 x32 with SQL 2005 Enterprise x32 with 3GB memory 2. Windows Enterpise 2003 x64...

rcamarda

05-12-2006 08:41 AM
rcamarda

Table 1: id1 name 10 - Monday 20 - Tuesday 30 - Wed.. 40 - etc Table2: id2 - name 5 - blue

JFO

05-12-2006 07:07 AM
jsfromynr

Hi All, I would like to set up transactional replication with failover cluster. Did anybody tried this? Does it work together? Is there anything...

laststubborn

05-11-2006 06:06 PM
Erland Sommarskog

Hi, I have a history table with about 400 million rows, with a unique composite nonclustered index on two columns (object id and time period) which...

sql_server_user

05-11-2006 05:33 PM
Erland Sommarskog

I have been trying for several days to create a peer-to-peer replication among three servers. I first created the publication on Server A, enabled it...

EoRaptor013

05-11-2006 02:21 PM
EoRaptor013

Expert OLAP Developer Westminster, CO 6 Months This position is in the Data Warehouse group. Candidate will be using MS technologies to develop...

mumbles

05-11-2006 12:29 PM
mumbles

I'm trying to copy all 440 million rows from one table in my SQL Server 2005 db to another table with a different clustering scheme. After a few test...

sql_server_user

05-11-2006 10:30 AM
sql_server_user

Hi, I'm starting a new application in java using JTDS jdbc driver (http://jtds.sourceforge.net) and SQLServer 2005 Express. I have to design the...

D.

05-11-2006 10:07 AM
joeNOSPAM (AT) BEA (DOT) com

Hello all, my question might be trivial but since my background isn't DB i'll dare to ask it any way: how to create a real (not virtual) table from...

groupy

05-11-2006 09:42 AM
groupy

SQL2K5 SP1 the autogrowth setting in one of my database's primary filegroup data file keeps having the value of 12800%, which was originally set...

XNMB

05-11-2006 08:38 AM
Erland Sommarskog

Dear all, I would like to know whether it's a good choice to index a column clustered where this column is intended also to be a full-text...

coosa

05-11-2006 08:33 AM
coosa

Dear All, We have a big concern in our Database system. We have 2000 transactions daily in our database. We need to replicate some how the database...

laststubborn

05-11-2006 08:31 AM
Greg D. Moore \(Strider\)

It's very simple import, without any data modifications; from several excel files to one table. I tried the wisard and it gives me selection for only...

AT

05-11-2006 05:52 AM
AT

We will soon have 200 + production instances. In an effort to be more pro active, I am looking for a way to monitor jobs, both failed and long...

AT

05-10-2006 06:00 PM
Erland Sommarskog

Hi Guru, I'm tired of trouleshoot one of my sql box that the sqlagent can't started. Here is the message: SQLServerAgent could not be started...

kmounkhaty (AT) yahoo (DOT) com

05-10-2006 12:36 PM
kmounkhaty (AT) yahoo (DOT) com

I am attempting to use the foreach loop structure in an SSIS package to loop through however many Excel files are placed in a directory and then...

davidz

05-10-2006 01:49 AM
Steve Kass

Hello all, Can someone help me with this SQL? 1) EMPLOYEE table has columns 'employee_id' and 'emp_sid' and other columns 2) EMPLOYEE_BENEFITS...

das

05-09-2006 06:13 PM
--CELKO--

Hi, I need to maintain both SQL Server 2000 and 2005 on my PC for support purposes. I am using the developer additions. After I install everything...

thomas_vicker (AT) standardandpoors (DOT) com

05-09-2006 05:36 PM
Erland Sommarskog

Hi, The tempdb file on one of our servers grew very large and used all available disk space. This is SQL Server 2000 SP4. I have installed hotfix...

SQL Server

05-09-2006 05:15 PM
Erland Sommarskog

I am creating an image gallery system, where there is an admin and multiple users upload images. Each user is restricted to uploading 8 images. ...

AT

05-09-2006 02:59 PM
AT

I know that this is primarily a SQL server group, but I am hoping someone has experience in running Oracle alongside SQL servers. We currently only...

KR

05-09-2006 12:19 PM
DA Morgan

Hello, I need to find students that have 4 consecutive absences. When a student is absent 4 times in a row, they can be dropped from the class. My...

rcamarda

05-09-2006 09:05 AM
--CELKO--

I am a newbie at C# (VS 2005) and SQL Server(2003). I was able to create a db using my old pc and then copied it to my laptop to my project folder,...

M K

05-09-2006 08:37 AM
Mark Kopple

Dear all, A well reputable group of companies in Pakistan we urgently required a System Support Engineer for our sister concern factory located...

Asim Khan

05-09-2006 02:16 AM
Asim Khan

Hi, Does anyone know if MS SQL Server 2000, will run stability on a Windows XP based O/S, using one of the new Dual Core chips, or HT...

David

05-08-2006 09:18 PM
pb648174

I need to monitor the Enable flag on SQL Jobs. Are the job's schedule and other information in a table somewhere? tia Rob

rcamarda

05-08-2006 06:45 PM
rcamarda

When I attempt to manage Transactions in a WHILE LOOP @@TRANCOUNT is off. I obviously do not understand error handling as I should. In the loop below...

rlm

05-08-2006 05:41 PM
Erland Sommarskog

We're running merge replication between to SQL Server 2000 servers. The application isn't very high volume the setup is pretty vanilla (ie...

ceadtinneh

05-08-2006 05:41 PM
ceadtinneh

Hi, I have an UPDATE statement which runs very slow (about 1-2 minutes) in Web as well as in Query Analyzer. Very plain UPDATE statement;...

AT

05-08-2006 05:34 PM
Erland Sommarskog

Hi all I have a large data set of points situated in 3d space. I have a simple primary key and an x, y and z value. What I would like is an...

AT

05-08-2006 03:25 PM
--CELKO--

Hi, We have been using ADO and the AddNew method for a long time as a means to add records to the database. It has always worked fine - no...

Mwob

05-08-2006 10:51 AM
Mwob