Viewing 15 posts - 301 through 315 (of 816 total)
contact details available in our Exchange server to our SQL DB
what do you mean by contact details?
If you looking for all the sql server in a domain then from...
February 24, 2011 at 11:18 pm
As your sql already running and to make the change effective in your sql , you have to change the sql services running account to the correct domain account if...
February 24, 2011 at 2:14 am
1)use order by ReminderNo asc/desc to see the list accordingly.
2) use top n in your select query to get top n number of records and use order by asc/desc to...
February 24, 2011 at 2:07 am
select * from sys.dm_os_sys_memory
February 23, 2011 at 10:27 pm
When you create your maintenance plan, you have the option to view the t-sql script of the maintenance plan(the task which you configured for maintenance).
To do this-- select edit of...
February 23, 2011 at 1:10 am
EXEC SP_EXECUTESQL @BUILDTABLESTR
like John mentioned, you need to look into your query which you passing into variable. There might be some object/s in query on which the user do not...
February 21, 2011 at 10:40 pm
i had this picture when I visited Madam tussads London.
I like to use this picture as my avatar because it inspire me for honesty and learning new every day....
February 17, 2011 at 4:13 am
is your sql server windows authentication or mixed mode authentication?
If mixed mode then you can login with some windows account which is configured with sa permission and then reset...
February 17, 2011 at 1:11 am
if you asking about general overview on log file growth then I would recommend you to go through this great article from Gail :-
http://www.sqlservercentral.com/articles/64582/
If your question about managing in your...
February 16, 2011 at 9:00 am
yes it will not refelct immediately as soon it reflect on your primary server.
As i mentioned the steps in my previous post, the backup file first get placed in...
February 16, 2011 at 4:36 am
if we select database it's showing error. database is not operational
what Gail is referring is to run this query in master database:-
select name, state,state_desc from sys.databases
and report about...
February 16, 2011 at 4:10 am
Have a read of dbcc ind and dbcc page.
You will get most of your answer.
February 16, 2011 at 4:07 am
When setting up LS there were 2 boxes called "Network Path to Back Up Folder" and "Destination folder for copied files". The first is straight forward, the second seems to...
February 16, 2011 at 3:14 am
What are the implications (for restore) in using the Copy_Only Back Up method?
as you can read here http://msdn.microsoft.com/en-us/library/ms191495.aspx, copy_only doesnt break your backup chain. So this option you can use...
February 16, 2011 at 2:37 am
Viewing 15 posts - 301 through 315 (of 816 total)