Viewing 15 posts - 1 through 15 (of 42 total)
Man..! I normally read all articles that are posted here at SQLServerCentral, some very good ones and some not that good. But ok, all topics can't interest everyone.
But when I...
robbac
___the truth is out there___
October 26, 2005 at 3:21 am
Indeed it is, as well as suggestions how to solve the problem.
robbac
___the truth is out there___
August 5, 2004 at 8:12 am
Hi!
You can, after open the cursor use FETCH LAST FROM <cursor_name> INTO <variable>
Good luck!
robbac
___the truth is out there___
August 5, 2004 at 3:04 am
Hi R.B.Verma!
There are many different ways to do this. One of ways are to find all duplicates and move one of them to a temporary table, delete all duplicate records...
robbac
___the truth is out there___
August 4, 2004 at 3:58 am
Hi Gopinath!
Would it be possible for you to use "TOP 1" and "ORDER BY" in your definition for the cursor so it only return one row for you?
robbac
___the truth is out there___
August 4, 2004 at 3:43 am
I'm glad that this help. Just fun to be of any assistance.
Have a nice weekend.
robbac
___the truth is out there___
July 30, 2004 at 3:13 am
Hi R.B!
To create the table use:
CREATE TABLE [dbo].[MyTable] (
[id] int not null identity(1,1) )
I don't quite understand your question about datatype. Have a look at this page from Books...
robbac
___the truth is out there___
July 29, 2004 at 8:12 am
Hi!
Just wanne check, did you set ProxyAccount1 as startup account for SQL Server Agent or as a Proxy Account in SQL Server agent?
Proxy account is addes in:
Right Click on SQL...
robbac
___the truth is out there___
July 29, 2004 at 4:07 am
Hi Firthr!
You write that the user had access to the table before you moved it into a new server. Did you re-create the user on the new server, or did...
robbac
___the truth is out there___
July 28, 2004 at 1:21 pm
Hi Jack!
Dynamic SQL is as bad as using cursors in SQL Server
First of all it is a huge sequrity risk to use dynamic...
robbac
___the truth is out there___
July 28, 2004 at 12:45 pm
Hi rmizzar!
It might be caused by what protocols that are used. I would try to first set the language to tcp/ip and if that does not work, to named pipes.
If...
robbac
___the truth is out there___
July 28, 2004 at 12:33 pm
Hi!
I don't think the error is about executing xp_cmdshell. If that would be the problem, then you should get an access denied instead. The error indicates that it's looking for...
robbac
___the truth is out there___
July 28, 2004 at 12:16 pm
Not 100% sure, but it might be the thing that you in your code for executing the dts-package use "/E" (trusted connection).
When you are logged in with a user with...
robbac
___the truth is out there___
July 28, 2004 at 8:01 am
Hi Hatim!
I belive you are looking for a sulotion published just a couple of days ago:
http://qa.sqlservercentral.com/columnists/SFilippidis/conditionalstatementsinwhereclauses.asp
Good luck!
robbac
___the truth is out there___
July 28, 2004 at 7:11 am
Sorry, but that's what I've done, tested the query that is. And it returns all the rows in the test-table that I have.
About the LIKE or = operators, of course...
robbac
___the truth is out there___
July 28, 2004 at 3:58 am
Viewing 15 posts - 1 through 15 (of 42 total)