Viewing 15 posts - 316 through 330 (of 497 total)
I've never tried that but I think it's a bad idea in general. If what you really need is access to the tables then look into using OPENDATASOURCE and OPENROWSET....
October 29, 2003 at 3:19 pm
Are you by chance getting an error on the update that is not getting rolled back and thus locking the table?
begin
set @rep_id = 'PIE'+convert(varchar(3)...
October 29, 2003 at 3:08 pm
I would simply backup the subscriber aa and copy the backup file to the new machine and restore it. This will lose your subscription information so there will be no...
October 29, 2003 at 3:02 pm
While SQL Server will drop them for you, I always clean up after myself when I can. It's just a good habit to do so. Also prevents errors if you...
October 29, 2003 at 2:56 pm
I've been doing SQL work for about 8 years as well as VB and ASP. A long time ago I started using Visual Studio for all my development work in...
October 29, 2003 at 1:16 pm
This is not allowed in SQL Server. I would use your dynamic sql to fill a temp table and then run the cursor on the temp table. Better yet is...
October 29, 2003 at 12:40 pm
The simplest way is to use a backup. Then restore the database on the new machine with the MOVE option.
However I'm not sure what you mean by the different server...
October 29, 2003 at 11:51 am
Your if exists could look like the following...
IF EXISTS(SELECT * FROM tempdb..sysobjects WHERE id = object_id('tempdb..#temptable'))
DROP TABLE #temptable
or a simpler version...
IF object_id('tempdb..#temptable')...
October 29, 2003 at 11:48 am
I really like Crispin's way of doing it. The nice thing about his version is that depending on how often the parameter is null you can switch it around for...
October 28, 2003 at 5:37 pm
You are missing your GROUP BY statement in the first query for the union. However I don't think that really gives you what you want. Try this...
October 28, 2003 at 5:29 pm
As Patrick stated and I tried to point out. If they are not using UNICODE characters then there is no benefit of going to an NTEXT data type. I don't...
October 28, 2003 at 5:22 pm
Going from text to ntext may not solve his problem. I'm pretty sure his problem is due to a problem in ADO and not SQL7. I tried to find the...
October 28, 2003 at 12:11 pm
Sandy,
I think you will have better luck with the following. Looking at your sql you had a couple errors that would prevent you from being able to run the...
October 27, 2003 at 8:30 pm
What I typically do in this case is to have a job that queries a table on the remote server. If there is a record in the table that needs...
October 23, 2003 at 9:01 pm
The problem is that SQL Server doesn't forward the login information through remote servers well. What I have always done is to set up a sql user on my linked...
October 23, 2003 at 8:27 pm
Viewing 15 posts - 316 through 330 (of 497 total)