Viewing 15 topics - 277,906 through 277,920 (of 283,821 total)
Topics
Started by
Posts
Last post
Hi! Can anybody helps me how to optimises a SP by using SQL Server profiler? What are the parameter…
4 replies
I've recently exported into a txt file using BCP. I used the following: exec master..xp_cmdshell '…
2 replies
Books Online: Write-Ahead Transaction Log - Microsoft® SQL Server™ 2000, like many relational datab…
4 replies
Is it possible to specify TableNames, ColumnNames as stored procedure parameters for be used in a S…
1 replies
for example: USE pubs GO /* Now is there a T-SQL statement to return which databasename I am c…
2 replies
Somehow I screwed up my database. MSDB is in read-only \ offline \ emergency mode. When I start t…
4 replies
Hello, In QA if I call a procedure as EXEC stpMySproc ' WHERE CompanyName LIKE ' + Char(39) + 'haa…
6 replies
Hello, In QA if I call a procedure as EXEC stpMySproc ' WHERE CompanyName LIKE ' + Char(39) + 'h…
2 replies
Is it possible or even safe to delete system stored procedures (ie - xp_cmdshell) from the SQL Serv…
1 replies
Does anyone know how I could deny sysadmin users from modifying data in a table? As far as I am awa…
3 replies
Hi everybody, When a job which was created from DTS package fails it writes a log to the Windows NT…
8 replies
A little off topic, sorry. Is there a way to save an ERwin document so my boss can view it without …
7 replies
Does anyone have an explanation to why subscriber tables in TX-Rep don't have primary keys? They h…
3 replies
I added a Push subscription to a merge publication. The subscription is being accessed via a VPN. W…
1 replies
Hi All, The management wants to use MKS Toolkit 8.1 (MKS Software Inc.) to back up SQL Server datab…
1 replies
Viewing 15 topics - 277,906 through 277,920 (of 283,821 total)