Viewing 15 posts - 3,331 through 3,345 (of 7,503 total)
Yes.. I thought of that... But creating a view in 80+ servers is hard task to do.. [w00t]
.
No that is not an issue at all !
Create a script for each...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
November 5, 2009 at 2:18 pm
have a look at Books Online ( highlight your "convert" keyword and hit Shift+F1 if your query pane )
That will open your local copy of books online and show info...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
November 5, 2009 at 2:12 pm
KP-249943 (11/5/2009)
We have a SQL Server 2005 (SP3), Enterprise (64 bit) edition.
The data is on the H:\ drive. The Transaction Log is on the F:\ drive. Both H:\ drive and...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
November 5, 2009 at 1:34 pm
also have a look at the demistifying article Gail Shaw posted http://www.sqlservercentral.com/articles/64582/
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
November 5, 2009 at 1:07 pm
scheney-1152259 (11/5/2009)
From what I've seen this question gets asked quite a bit, but I can't get a solution that works for me.
I am running a database using SQL Server...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
November 5, 2009 at 1:05 pm
Currently SQL2005 is on SP3 for a while now ! You should evaluate it and upgrade if you can !
The logon trigger (available with sp2) is only validated...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
November 5, 2009 at 7:35 am
Tara-1044200 (11/4/2009)
example:2TB of databases containing 20 yrs...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
November 4, 2009 at 2:39 pm
If you have SQL2005 SP2 or higher have a look at http://www.simple-talk.com/sql/sql-server-2005/logon-triggers/
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
November 4, 2009 at 2:19 pm
- please post in the correct forum ! ( this is a sql2005 forum )
- the lack of SQLAgent manager role is one of the weak spots of SQL2000 ...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
November 4, 2009 at 12:56 pm
HTH
Keep in mind that if you are using sqlauthentication and didn't migrate the sqluserid including the SID, you must resync the user ids using:
-- to be executed per sqluserid !
exec...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
November 3, 2009 at 1:45 am
What issue did you encounter to validate the need to uninstall the sp ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
November 1, 2009 at 4:25 am
Robert Frasca (10/30/2009)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 31, 2009 at 3:29 pm
it isn't mandatory, but it helps for sure :-P:-D
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 31, 2009 at 4:35 am
I posted my SQL2005 script, because you posted in the SQL2005 forum !
for sql2000 you can use:
SET NOCOUNT ON
SET ROWCOUNT 1000
WHILE 1 = 1
BEGIN
DELETE TableName WHERE <Your Condition Here>
...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 30, 2009 at 6:33 am
Anamika (10/30/2009)
thanks,but to take a back up i don't have space in the server. it'z a 200gb database.
regards,
anamika
You can also produce the backup to a remote location, provided you grant...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
October 30, 2009 at 4:44 am
Viewing 15 posts - 3,331 through 3,345 (of 7,503 total)