Viewing 15 topics - 270,841 through 270,855 (of 284,140 total)
Topics
Started by
Posts
Last post
I'm developing in MS SQL Server 7.0 environment. This is the script for the trigger: CREATE TRIGGER…
1 replies
From the EM/Management/Current Activity/"Locks / Object", there are a few objects are locked. If I …
6 replies
We have 6 'runaway' processes running aganist a linked server which I cannot KILL. Is there any oth…
4 replies
Hello, I created a trigger on tblDelete. Aftering inserting a record in tblDelete it will delete t…
1 replies
DBCC Reindex & DBCC Indexdefrag I have my database on two files (but one file groups). My unde…
4 replies
I have installed sql 2000 sp3 on a test server and have a question about cross-database ownership c…
2 replies
Hi I currently use COALESCE while updating tables so that if the input parameter is NULL(defaulted)…
4 replies
When running sql output to a file, SQL server likes to tack on 2 extra blank lines at the end with …
3 replies
Below works great except for the question about 5-6 lines down). The line "@Position = @Position 2"…
3 replies
I have 2 tables whith the same structure and i'want to find all the values from table1 where not ex…
11 replies
How do I build a string to use in the IN part of a WHERE clause.
3 replies
Hi there! Is there a (simple) way to replicate an entire database (SQL Server 2000) in code (T-SQL/…
4 replies
Hello! Sorry to put this subject inside the backup folder. How can I store a password for a user s…
9 replies
I'm having an odd problem with tempdb. I have moved tempdb to another drive, locked down the develo…
3 replies
Hello , the sql will not delete from the tables if more then 2 rows have to be deleted... can somb…
1 replies
Viewing 15 topics - 270,841 through 270,855 (of 284,140 total)