Viewing 15 posts - 991 through 1,005 (of 1,179 total)
refer the following link for monitoring:
http://msdn.microsoft.com/en-us/library/ms190224.aspx
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 21, 2009 at 6:05 am
Hello,
Solution is very simple you need to copy the code to query analyzer and change the database to "production" and than execute the script.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 20, 2009 at 12:24 am
Already John has mention:
BOL Topic “ALTER SCHEMA (Transact-SQL)”.
system shcema could not change.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 19, 2009 at 5:02 am
If possible you can stop and start services "SQL Browser".
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 19, 2009 at 4:40 am
Default instance should not be a problem to set up the logshipping. More detail about your issue will help to guide you.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 19, 2009 at 4:21 am
In my openion, it doesn't make much differnece if you cahnge before or after the upgrade.
On Database side it's very easy to change the dbname. But more work needs...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 11, 2009 at 9:41 pm
In BOL; I do not found status value like 4194320, 4194328.
What is the status of the database?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 8, 2009 at 11:43 pm
In SQL Server Agent Create Operators and in Notification options-Email nme: write the e-mail address by seperating ";"
e.g. email1@email.com; email2@email.com etc.
Simply Assign this operator to notify.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 6, 2009 at 3:01 am
What is the recovery mode of your database? Is your database accessible?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 6, 2009 at 2:09 am
I guess; "A user to act like another user"
looks correct answer as per the following MS article:
http://msdn.microsoft.com/en-us/library/ms188304.aspx
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 6, 2009 at 12:39 am
In addition to the above, I guess Replication do not require index on all the columns. But it require a Cluster Index to get the article replicated.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 6, 2009 at 12:31 am
Check the credentials and findout job owner is having access to FTP.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 6, 2009 at 12:30 am
Think about composit index.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 6, 2009 at 12:13 am
You can also check if any opent transactions are there or not?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 5, 2009 at 5:51 am
Hello Rechard,
You can also think about the new feature of SQL Server 2008 "Compress Backup" to save disk space & time.
Also if you are not using 2008 than you can...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
January 5, 2009 at 5:45 am
Viewing 15 posts - 991 through 1,005 (of 1,179 total)