Viewing 15 posts - 496 through 510 (of 824 total)
I would check @@version just to be sure that no post SP3 patches have been applied. That could cause some issues.
May 25, 2005 at 9:55 am
SQL Server isn't intended to be used to "share" other executables. It manages and provides shared access to data which is stored in tables. The data can be used by...
May 25, 2005 at 9:52 am
This is by design. Only a BACKUP LOG... command will truncate the log.
May 25, 2005 at 9:47 am
When you specify 'sa' as your @locallogin you will only be able to use the linked server if you are connected as sa. If you want other users to be...
May 25, 2005 at 9:45 am
I wasn't aware of that limitation, but then again, who would create multiple log files? Although I'm sure it's been done, it isn't something that normally factors into my equations...
May 25, 2005 at 8:46 am
OK, so you are trying to add an IDENTITY column to an existing table and populate the data for the existing rows appropriately?
The easiest way would probably be to create...
May 25, 2005 at 8:38 am
McCown's article was based on a couple of incorrect assumptions. The first (and worst) is that if you have a GUID it would be the clustered index. This is a...
May 24, 2005 at 1:34 pm
You can still use sp_attach_db to attach multiple data files without specifying a log file.
May 24, 2005 at 1:20 pm
I can provide a basic schedule database diagram.
May 24, 2005 at 12:08 pm
Wow, I guess I've been doing the impossible for years! I need to ask for a raise!
May 24, 2005 at 8:37 am
I'm not sure I know exactly what you mean, but there is a DigitalProductID in HKEY_Local_Machine\Software\Microsoft\Microsoft SQL Server\80\Registration
I'm not positive that this is a truly unique identifier for each installed...
May 24, 2005 at 8:33 am
The MAPI client is normally Outlook. If you log onto the server using the SQL Server Service account (if SQL is running under Local System you won't be able to...
May 24, 2005 at 8:25 am
I'm a bit unclear on what you need, but you can install multiple versions of Windows on a single machine if you use something like Virtual Server or VM Ware. ...
May 23, 2005 at 1:47 pm
I had been lead to understand that the Windows defrag IS the Diskkeeper engine with none of the automation features available...
In any case the Diskkeeper product is usually well worth...
May 23, 2005 at 12:54 pm
I have desinged several schedulers like what you mention. If you want an example of how NOT to do it, you can look at msdb.sysjobschedules. Yeah, it works, but what...
May 23, 2005 at 11:29 am
Viewing 15 posts - 496 through 510 (of 824 total)