Viewing 15 posts - 3,016 through 3,030 (of 3,233 total)
I'm not sure I understand the question. This comes from BOL, maybe it will help: 'Contains one row for each stored procedure and function accessible to the current user in...
February 17, 2006 at 11:05 am
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
Viewing 15 posts - 3,016 through 3,030 (of 3,233 total)