Viewing 15 posts - 42,391 through 42,405 (of 49,571 total)
ps (12/14/2008)
Gail, I think he needs to run 2nd SP for each Row.
I don't think so, seeing as he was asking how to pass a resultset to a stored...
December 15, 2008 at 12:10 am
gamaz (12/14/2008)
December 15, 2008 at 12:02 am
Nicholas Cain (12/14/2008)
I am sure that there are far more elegant versions of this that would work with a simple convert, I just couldn't figure any out.
I don't know about...
December 14, 2008 at 11:52 am
ps (12/14/2008)
You can also use cursors or Loop within the first SP and calling the 2nd SP for each rowset from within the cursor/loop.
You can, but that's an exceedingly slow...
December 14, 2008 at 11:44 am
If you can, create a NC index to support the other searches on the table. If that's not possible, or you want a NC just for the count, then put...
December 14, 2008 at 11:36 am
Grant Fritchey (12/14/2008)
To really answer the question, you've got to post the execution plans.
And the query, the table schemas and index definitions please.
December 14, 2008 at 8:52 am
If it's a desktop at home, local system's fine.
It's not recommended for use in production systems because it has too many privileges and has no access to other machines.
December 14, 2008 at 8:48 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic619044-146-1.aspx
December 14, 2008 at 2:42 am
timothyawiseman (12/13/2008)
December 14, 2008 at 2:39 am
udayaraju_v (12/12/2008)
I need Login as "sa" and empty Password ""..is ther any possibilty..please suggest me...
I would very, very strongly recommend that you do not do that. A server with the...
December 13, 2008 at 2:54 am
What's the error?
For the full error, go to the job step properties, to the advanced tab and enter a file name for the job output. Full error will be in...
December 13, 2008 at 2:47 am
You can query sys.dm_exec_sql_text and pass it a sql_handle (which you can get from sys.dm_exec_requests and several other DMVs)
It's not exactly the same output as inputbuffer. Inputbuffer will show the...
December 13, 2008 at 2:46 am
nairsanthu1977 (12/13/2008)
Whats native restoration process..? Can you explain in detail pls..
RESTORE DATABASE ... FROM ...
See books Online for the full details. Or, from Object Explorer, right click the databases folder...
December 13, 2008 at 2:43 am
Try attaching them. It should work.
From object explorer, right click the database folder and select Attach Database
December 13, 2008 at 2:42 am
ALTER TRIGGER [dbo].[trTest]
ON [dbo].[NotesF_Devices]
AFTER UPDATE
AS
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT...
December 12, 2008 at 1:14 pm
Viewing 15 posts - 42,391 through 42,405 (of 49,571 total)