Topics
Started by
Posts
Last post
How do I test for tmp tables??? I want to test if the tmp table exists if so drop tmp table. Steve …
3 replies
Hi All, When using a query in a dts package, functions parse as valid SQL, however usually the dts …
1 replies
Hi, I run a bcp command inside my sql analyzer. I did this: master.dbo.xp_cmdshell "bcp dbname.dbow…
3 replies
Hi, I had never used bcp before. So I got a lot of questions to ask about bcp. First, how to run bc…
10 replies
Hi All, I want to use Begin Transaction and Commit Transaction in my trigger. But when I used it an…
4 replies
Hi, according the book, Microsoft SQL Server 2000 DBA Survival Guide, in order to achieve fast mode…
4 replies
Providing the following information:- SQL Server: 7.0 Database Name : TestDB Table Name: TestTBL (F…
3 replies
Question : Is ther a way to create a table using a dynamic name like : Declare @tablename as varcha…
6 replies
I developed this procedure that when executed will grant or revoke privlages to users or user group…
1 replies
Hi, I am trying to construct a dynamic sql containing a table varaible as this: declare @mv_table t…
3 replies
Hi, we are porting our software from oracle to sql server. In one of our tables in oracle db, we ha…
4 replies
How to lock a table in sqlserver?
2 replies
I came across this feature mentioned whereby you can store Word documents and conduct full text sea…
3 replies
I heard that all sp_ store procedures will be recompiled everytime you execute them, Is it true?
1 replies
I'm having trouble understanding the scope and availability of temporary tables to my stored proced…
1 replies
Viewing 15 topics - 4,246 through 4,260 (of 4,454 total)
You must be logged in to create new topics.