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...
October 26, 2005 at 3:21 am
Indeed it is, as well as suggestions how to solve the problem.
August 5, 2004 at 8:12 am
Hi!
You can, after open the cursor use FETCH LAST FROM <cursor_name> INTO <variable>
Good luck!
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...
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?
August 4, 2004 at 3:43 am
I'm glad that this help. Just fun to be of any assistance.
Have a nice weekend.
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...
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...
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...
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...
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...
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...
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...
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!
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...
July 28, 2004 at 3:58 am
Viewing 15 posts - 1 through 15 (of 42 total)