I believe that means you should create a new database on the SQL Server in question.  There are various ways of doing this (right-click on the database folder in Management...

Hi Cory,

Everything is possible - nothing is impossible .

To enumerate the contents of a drive (or folder) from SQL Server you can use the following...

Hi Justin,

Yes, that would be quite easy. Just add another parameter called @length (datatype tinyint).

Then, inside the function, the while statement can be:

while len(@result) < @length

When you call the...

Hi Justin,

Given that you're using SQL 2000 you cannot create a CLR function but you can do this easily enough using a standard user defined function that accepts an numeric...

James,

The error suggests that you might have another column (in addition to the primary key column) that has a unique constraint on it.

Run sp_help against the table and check out...

Hi Jennifer,

That's just the way it is.  SQL Server is greedy in that way .

Basically, an internal SQL Server process (LazyWriter) continuously polls the system...

Hi Miquel,

Try this:

select object_name(constid) as constraint_name
,object_name(fkeyid)...

Hi Jennifer,

When using dynamic memory configuration, as you have done, SQL Server is designed to take as much memory as it needs (up to the max limit).  So in your...

Hi,

A composite key is one that uniquely identifies a row by utilising more than one column.  For example consider a table called Book, which contains details on books.

To uniquely identify...

Hi Hendy,

a SQL Server 2000 to 2005 migration should not require any manual changes of tables, stored procs unless you have code that directly accesses system objects that have been...

Response is here

Please limit yourself to one post per question.

Response is here

Please limit yourself to one post per question.

Hi Hendy,

Both models you have described are centralized models.  The first one is a connected and the second one is a disconnected model.

I favour the second model, perhaps with some...

Yep,

I'd agree with Pam.  DTS is probably the better option.  Replication is a lot more involved and will need a close eye to ensure thing are running smoothly.

Hi Crystal,

Putting the system database log files on a seperate drive isn't necessary.  The system databases don't change much and as a result there is probably negligible I/O activity on...