Viewing 15 posts - 2,236 through 2,250 (of 2,387 total)
I don't think SQL Server login (SQL Server authentication) has effect to him but if the login is NT login (NT authentication) and I would say yes.
Can you run sp_helplogins...
February 6, 2003 at 8:21 am
Is this particular user's NT login be granted to access SQL Server without 'sa' right outside the LocalSQLAdmins group in your SQL Server?
February 6, 2003 at 7:31 am
How large your database is? If you have sufficient disk spaces, You can backup the database to the local disks first and move it to tapes later.
February 6, 2003 at 7:23 am
I don't see they are related directly.
By the way, In order to optimize the database performance, DBCC DNREINDEX should be performed regularly too.
February 5, 2003 at 2:11 pm
Upgrade to SQL Server 2000 also upgrades MDAC to 2.6. This may related to your problem. Try to upgrade MDAC component to 2.6 too in your workstation machine which you...
February 4, 2003 at 1:42 pm
I guess you are talking about security patch ms02-061 for SQL Server 7.0. I installed it to two machines and have no issues.
Before you apply the patch, you must install...
February 4, 2003 at 11:50 am
Better find out where it is. It should be in master database.
February 4, 2003 at 10:40 am
Do you have proper permission? Execute permissions for xp_cmdshell default to members of the sysadmin fixed server role.
Try to login as 'sa' and see whether you still have same problem.
...
February 4, 2003 at 10:05 am
Can you post your SQL statement for the restoration?
You should restore full database with 'norecovery' option and then restore the differential backup with 'recovery' option.
For example,
restore database pubs from disk...
February 4, 2003 at 9:27 am
Shutdown application, detach the database, move the database files to new location and re-attach the database.
If you want to move SQL Server system files, you have to uninstall SQL Server...
February 4, 2003 at 9:20 am
I have same problem. Can you post more details information. Thanks.
February 3, 2003 at 2:43 pm
Quoted from BOL.
"fill factor Option
Use the fill factor option to specify how full Microsoft® SQL Server™ should make each page when it creates a new index using existing data. The...
February 3, 2003 at 2:32 pm
Don't replace the 'IndexFillFactor' with 0
Here it is.
select INDEXPROPERTY (1109578991, 'PK__BSKT__52AE4273', 'IndexFillFactor')
February 3, 2003 at 2:16 pm
Can you run select INDEXPROPERTY (object_id('yourtablename'), 'yourclusterindexname', 'IndexFillFactor'). Sorry for gave you wrong syntax.
Use sp_helpindex yourtablename to get cluster index name
February 3, 2003 at 1:51 pm
What is the fill factor setting? You may consider adjustmnet of fill factor for this table alone.
Run sp_configure to see the server wide setting for fill factor.
select INDEXPROPERTY (YourTable_ID ,...
February 3, 2003 at 1:13 pm
Viewing 15 posts - 2,236 through 2,250 (of 2,387 total)