Forum Replies Created
Viewing 15 posts - 496 through 510 (of 824 total)
-
RE: Enterprise to Standard Edition
I would check @@version just to be sure that no post SP3 patches have been applied. That could cause some issues.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: I''''m a total NewB and need help!!!
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...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Full backup, Log file not cleared
This is by design. Only a BACKUP LOG... command will truncate the log.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Linked server to MS Access...
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...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Attaching database with data files only - URGENT
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...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: GUID performance article in recent edition
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...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: GUID performance article in recent edition
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...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Attaching database with data files only - URGENT
You can still use sp_attach_db to attach multiple data files without specifying a log file.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Scheduling functionality
I can provide a basic schedule database diagram.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Import from XML to SQL Server 2000
Wow, I guess I've been doing the impossible for years! I need to ask for a raise!
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: multiple server question
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...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: MAPI status of sql 2000 server
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...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: multiple server question
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. ...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: SQL Optimisation Vs Disk Defrag?
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...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
-
RE: Scheduling functionality
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...
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
Viewing 15 posts - 496 through 510 (of 824 total)