Viewing 15 posts - 106 through 120 (of 488 total)
Because without the parenthesis, SQL Server thinks you are providing the name of a stored procedure and it can't find one with that name.
February 20, 2004 at 10:05 am
Sorry I didn't catch this the first time around.
You need to change the line that reads:
EXEC @select_stmnt
to:
EXEC (@select_stmnt)
February 20, 2004 at 9:49 am
Merge replication might be what you want then. I just looked at ours and the tables we have merg replication on have the primary key on the publisher and subscriber...
February 20, 2004 at 9:45 am
We have found that functions in stored procedures work fine if the result set using the function is small. The larger ones tend to run too slow. I would simply...
February 20, 2004 at 8:46 am
If doing it manually is an option, then you can use Enterprise Manager. If you want a script to remove it you can go to the design view in Enterprise Manager,...
February 20, 2004 at 7:53 am
I spend time organizing the layout of my DTS packages and would not want them arbitrarily changed. If yours are organized for ease of understanding them then your best option...
February 20, 2004 at 7:30 am
I would try using a local temp table. It should work for you as long as only one connection (the one that created the temp table) needs access to that...
February 20, 2004 at 7:10 am
I have used transactional replication to create a copy of a server. I don't know if this is the best way. I have heard about log shipping and it could...
February 19, 2004 at 7:57 pm
If you are using local temp tables then SQL Server ensures each name is unique.
If you are using global temp tables then you must ensure the names are unique.
How...
February 19, 2004 at 7:01 pm
In your cursor you declared one column in your select list. Then you use the FETCH command to try and get the cursor to fill two variables with values from...
February 19, 2004 at 6:51 pm
I too find that xp_logevent logged to the SQL Server log and to the Event Viewer Application Log. I have never heard of Windows Application Application Log. Can someone please...
February 6, 2004 at 6:50 am
Another one came to mind.
A DBA should ensure the simplest code to do the job is being used. Sure, its nice to know VBScript and use it in DTS packages...
January 26, 2004 at 7:14 am
In my opinion, special mention should be made about notifications when something goes wrong. This probably should be a part of Canon 3.
A DBA must do everything they can to...
January 26, 2004 at 6:35 am
Our DBA just opened a ticket with Microsoft. Hopefully, we'll get some useful info from them.
January 21, 2004 at 11:18 am
Viewing 15 posts - 106 through 120 (of 488 total)