Viewing 15 topics - 280,756 through 280,770 (of 283,805 total)
Topics
Started by
Posts
Last post
I was using: -- Connect to Access EXEC sp_addlinkedserver @server = 'MSProject', @provider = 'Mi…
5 replies
Is it possible to execute a User sp from a DTS package. I have multiple cursors within the sp. thanx
1 replies
How can I make the data I retrieve from a pass through query in Access updateable? any ideas? thank…
1 replies
We have a couple of complex processes that generate thousands of rows spread across four tables. T…
1 replies
I want to do this, i don´t know if it is posible declare @name_table1 select * from @name_table1 I …
4 replies
does the order of the tables in my select statement have any relevance to deadlocks? ie. will SQLse…
1 replies
I want to be able to use a variable for the database name in a stored procedure, eg select * from @…
7 replies
CASE 1 Usual steps load data 1. table is created 2. data is inserted 3. clustered index created CAS…
3 replies
I have a stored procedure consisting of multiple IF statements that union the various queries toget…
7 replies
Hi, We are having some issues with people changing database objects (such as stored procs) and thus…
6 replies
Hi, I have passed 228 and 229 and am looking at doing 70-019 as my elective. Firstly, can anyone …
2 replies
Can anyone explain the scope of SCOPE_IDENTITY() within a stored procedure... What if two seperate …
1 replies
When trying to drop some filegroups with EM, I'm running into some trouble. Before the group can b…
15 replies
Hi, I'm trying to concatenate the values of a column over mulitple records into the column of a sin…
5 replies
I was wondering if there is an easier way to move logins and thier users from sqlserver 6.5 to 2000…
2 replies
Viewing 15 topics - 280,756 through 280,770 (of 283,805 total)