Viewing 15 posts - 42,391 through 42,405 (of 49,566 total)
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
Steve Jones - Editor (12/12/2008)
First thing I do, and used to require in dev teams, is to set tools to replace tabs with spaces. Creates all kinds of issues.
I used...
December 12, 2008 at 9:27 am
The_SQL_DBA (12/12/2008)
1.How is the process supposed to work?
That's a bit of a vague question.
How would the process of querying the table with ref to this column work after encryption?...
December 12, 2008 at 9:25 am
jcrawf02 (12/12/2008)
lol y'all are nuts.
Hehehe :hehe: You only just noticed?
December 12, 2008 at 7:12 am
In the first statement, both of those numbers are integers. When SQL does maths on two integers, the result will be an int. In this case, the result is too...
December 12, 2008 at 4:24 am
There's often more than one entry in that view. Try the following and see if there's more than one entry and, if so, if one of them has a uow
select...
December 12, 2008 at 4:22 am
Viewing 15 posts - 42,391 through 42,405 (of 49,566 total)