Topics
Started by
Posts
Last post
Hi Guys one of my application locking these objects sp_setapprole sp_add_log_file_recover_suspect_d…
9 replies
Why do .MDF files open in notepad? (when the server is stopped of course) Isn't this a big security…
8 replies
Does this have to read the whole table or only the top? select top 1000 place_of_svc from medical_…
7 replies
I need to know if there is a way to script all the stored procedures with ENCRYPTION..automatically…
7 replies
Profiler has traced Lock:Timeout occuring in system processes (SPID 9 and 13) that are running Task…
1 replies
Can someone explain the SQL Server performance counter 'Number of Deadlocks/sec' in SQLSErver:Locks…
2 replies
Hello, Does anyone know of a way that I can schedule a job / DTS package that would script out all …
7 replies
Hello, I'm a contract DBA for a small company and my client wants me to recommend changes to their …
3 replies
[SQL Server 2000 Enterprise Edition on Windows 2000 Advanced Server.] This is a disaster that I rec…
7 replies
We want our contractors to have read capability on SQL Server Jobs, but not be able to modify them.…
2 replies
Question for everyone regarding how Sql Server handles datetime datatypes. Is there an easier way …
6 replies
I've looked in BOL and the various posts and articles on this site, but cannot find any specific in…
3 replies
I am having problems with the syntax on adding a primary key to an existing table. I can add it th…
2 replies
Hi everyone, our database architecture is set up so that our data is on RAID 5 and our indexes are …
3 replies
found my own answer ALTER TABLE [dbo].[ClassCodes] WITH NOCHECK ADD CONSTRAINT [PK_ClassCodes] PR…
1 replies
Viewing 15 topics - 14,716 through 14,730 (of 16,171 total)
You must be logged in to create new topics.