Viewing 15 topics - 273,316 through 273,330 (of 283,948 total)
Topics
Started by
Posts
Last post
Is there a way to grant a user execute permission on all stored procedures created now and those cr…
3 replies
Why doesn't this work SELECT * FROM #NEWTEMP UNION SELECT asg.ASGN_STAT_CODE, asg.ACTUAL_STAR…
9 replies
Hi I have created new user in SQL 2000 db and want to assign him only permissions to Create/ALTER p…
5 replies
I am trying to utilize the variable DTSStep_DTSActiveScriptTask_X (where X refers to the task numbe…
1 replies
From QA ver. 8.00.760 CREATE TABLE #s1(seqnum int) insert into #s1 values (1) drop #s1 Run above co…
1 replies
I am running SQL2000 SP3 on a win2k server. I have 2 DBs on the server with one DB subscribing to …
3 replies
Can anoyone advise me: Is using a Linked Server the best way to replicate or duplicate data (i.e. i…
2 replies
What are the minimum sql permissions needed by a user to view\create a database diagram? Bill
2 replies
my problem is that I have a dynamic stored procedure which has 10 parameters such as @param1.....@p…
4 replies
I am new to MDX and need to crate a cube that can report a moving 12 month total of distinct patien…
1 replies
I am asking, if anybody know how to import DTS pakage with T-SQL script? I wouldn't like to use Ent…
5 replies
I am running SQL v7.0 and have over 100 DTS packages that have been setup and jobs scheduled agains…
5 replies
I’m hoping that someone can help me improve the speed of a SQL database restore. The following SQL …
8 replies
Not real happy with the choices on this QOD. The reason the developer is attempting to HOLDLOCK is…
18 replies
Hi all, I have a job scheduled every hour to backup transaction logs for all user db's. Now everyth…
8 replies
Viewing 15 topics - 273,316 through 273,330 (of 283,948 total)