Viewing 15 posts - 106 through 120 (of 219 total)
SET ANSI_NULLS Can be defined at there levels, for that mater any SET commands 1) Server 2) Database (Overwrites the server settings) 3) Session (Overwrites the Server and Database Settings).
...
July 11, 2003 at 8:18 am
Yes you are right, SQL Server creates these to keep track of non-index statistics on columns, to capture the statistics even though there is no physical index on that. Since...
July 11, 2003 at 8:09 am
My guess is you already have 250 indexes on that table. Check your sysindexes table. Execute the following query and see how many rows it returns. If it returns 250...
July 10, 2003 at 12:30 pm
Try to the following if you can
1)BCP out the X table data
2)Script the table X
3)Drop the table X
4)Do some objects creation and manipulate your trigger
5)Create table X from the script...
July 10, 2003 at 10:51 am
MS says they resolved this in SP1? Are you still getting the error
July 10, 2003 at 10:22 am
Sounds like SQL 6.5, any ways Launch a trace flag and see what other transactions going on. Also use sp_who2 in QA
Check out the following one
http://sqlservercentral.com/memberservices/updatescript.asp?Approve=y&scriptid=819
July 10, 2003 at 10:15 am
Yes you are right a5, when you see the tables from the EM, it may not show the tables in the Task pad view if the table does not have...
July 10, 2003 at 9:12 am
What's your SQL Version and Service pack?
EDIT - Also where the backup taken ?
July 10, 2003 at 8:47 am
What's your SQL Version and Service pack?
July 10, 2003 at 8:45 am
By default a public user can access/ modify/ Delete the DTS packs. Deny the permissions on sp_enum_dtspackages and sp_add_dtspackage stored procs in the msdb to prevent
July 9, 2003 at 1:44 pm
It will give you the option to choose from 1) Delete rows from the Destination table or 2) Append rows to the Destination table. Click on the small button in...
July 8, 2003 at 3:43 pm
I’ve seen this couple of time on one of the stage server. MS says you will get this kind of error messages if your server is with more than 3...
July 8, 2003 at 3:11 pm
Several ways Log shipping, Replication and clustering. Clustering is expensive to implement
July 8, 2003 at 11:54 am
To my knowledge you must be in the domain and you must have either Terminal client/ Remote desktop/ PC Anywhere installed. Good question to a hacker though
July 8, 2003 at 9:48 am
Viewing 15 posts - 106 through 120 (of 219 total)