Viewing 15 posts - 3,016 through 3,030 (of 3,232 total)
Ah, I thought you wanted more free space, but you really want to pack your indexes in, leaving only a small space. Zero is the default fill factor. Use sp_configure...
February 16, 2006 at 12:45 pm
SQL Server uses Fill Factor only while creating indexes. Fill Factor is not maintained after the index has been created. Therefore, the only way to change the fill factor is...
February 16, 2006 at 11:04 am
February 16, 2006 at 9:47 am
Are both machines in the same domain? You may want to attempt to use the same SQL Server account that your ADO object is using and try to connect via...
February 16, 2006 at 9:22 am
How are you attempting to connect to SQL Server? ODBC? Are you using Windows Authentication or SQL Server authentication? Is your PC running Windows XP SP2? If so, turn off...
February 16, 2006 at 9:00 am
In that case, your suggestion of creating tables similar to the system tables will work. I can not think of a better way.
February 14, 2006 at 9:02 am
While I do not have specific experience with ActiveX and Excel, I would think that you need Excel installed on your server if you expect ActiveX to be able to...
February 13, 2006 at 4:10 pm
Judging from the article in your post, you cannot take advantage of the 3GB switch if you are only running Windows Server 2000 standard edition.
February 13, 2006 at 2:12 pm
It should be....http://support.microsoft.com/kb/833722/en-us
February 13, 2006 at 12:46 pm
If you've re-installed SQL Server, I would restore your master and msdb databases also. All of your job and backup history is stored in the msdb. Restoring your master and...
February 13, 2006 at 11:14 am
AWE and /PAE allow you to take advantage of memory above 4GB. By default, SQL Server will consume 2GB of the base 4 and leave the other 2GB for the...
February 13, 2006 at 11:01 am
Can you give me some background on what happened to this server that you need to re-install SQL Server? I would recommend first un-installing SQL Server and doing a fresh...
February 13, 2006 at 10:57 am
You mentioned that the reason why you cannot use SQL Server's constraints to enforce referencial integrity because you need to import legacy data. How often is this legacy data being...
February 13, 2006 at 10:40 am
I am kind of confused here. So you've already applied SP4 to your instance and you had to restore you data files for a user database? When you apply a...
February 13, 2006 at 10:00 am
On the schedule tab of the job, you can select 'Start Automatically when SQL Agent starts'. This will run the job each time SQL Agent starts.
February 10, 2006 at 3:05 pm
Viewing 15 posts - 3,016 through 3,030 (of 3,232 total)