Viewing 15 topics - 268,666 through 268,680 (of 271,640 total)
Hello, I' m new in this forum and hope anybody can help me.
We 're now planning to upgrade our syst…
18 years, 2 months ago
I am having difficulty in changing my sa password from blank to a real password. Everytime I try t…
I used SQL 2000 Profiler to trace certain table read access. I have set up event and filter…
By: Prakash Heda
I currently need to be able to select the top N records based on a parameter that is passed in from…
Hi, is there any big difference between
isnull and coalesce? Thanks.
Yes, I AM a noob.
How do you delete rows from multiple tables? I have three tables and I want to de…
I am trying to write a trigger that updates a column of the record being updated in the sam…
By: Andy Warren
My developers have built an application that requires a table to be truncated. I don't give them t…
I am wondering how I can check the status of every transaction within an active X script. Below is…
By: Sachin Dedhia
If select into clause is used into transactions till the transaction commits sysobjects table can n…
In: Performance Tuning
How do i assign the Binding table for the Data Driven Query Task? MSDN states that this is done thr…
In: Data Transformation Services (DTS)
Hello, How can I pass or define a variable type table to a store procedure in SQL server?
A long time ago, I read that so long as your code/application doesn't mind, you can use the WITH(NO…
Is there a way to make your server default to dbo owner when creating a table, etc. I have develop…
Is it possible to have a Foreign Key in one db1 and its referenced table in db2 in another.