Joe

If I understand correctly, then each of the attributes will correspond to a column that the user can create dynamically.  If you have a finite list of these, why not...

Chris

Just to add to what Sameer said (apologies if I'm just repeating what's in the links he gave):

Don't shrink your database or log files if they're only going to grow...

For the most part, SQL Server doesn't really care that it's running on a cluster.  I've never tried to rebuild master on a cluster, but I don't imagine the procedure...

Claudia

Sorry, I don't know anything about dBase 5.  You'll probably have to write something in VB or ActiveX for your DTS package that generates the file name according to the...

Claudia

What is a .dbf file?  Is this in Access, or SQL Server?  If it's SQL Server, are all the files in the same filegroup, or is each one in its...

Michelle

If the login name is just Admin and not DomainName\Admin then that suggests it's a SQL login, so I'd say it won't be anything to do with BUILTIN\Administrators, which is...

Yes, just back up the database and restore it on the subscriber.  Then, when you create the subscription using sp_addsubscription, use the @sync_type = 'none' parameter to tell SQL Server...

You can get an estimate of I/O and CPU cost, but in order to translate that into an execution time, the query optimiser would have to guess what hardware you...

Dinakar

The way I understood it, Gavin already has a publication set up and wishes to add another article by restoring the database.  Therefore, I think the safest way is to...

Andrew

You're not going to like this, but I'm afraid it looks like your only choice is to hack your stored procedure and remove the identity column from it.  This seems...

Andrew

1.  There's an option in the properties of the Snapshot Agent to run a script before and/or after the snapshot is run.  I think the only way to do what...

Andrew

1. The terms "primary key" and "index" are not synonymous.  A primary key is a constraint on a column or group of columns such that the value(s) in the column(s)...

You can select getdate() at the beginning and end of the query, but bear in mind this will only be accurate to 3ms.  You can also run Profiler and look...

Gavin

Yes, there is.  Script out the articles you have already created, drop the subscription, restore a backup of the publication database to the subscriber, recreate the subscription using sp_addsubscription with...

No, that's not right.  All NOINIT does is tells SQL Server whether to overwrite what's already in the backup file.  So if you'd backed up with INIT, then Tuesday's differential...