Viewing 15 posts - 496 through 510 (of 707 total)
Why don't you download and install SQL Server Express.?
It's free right..?
October 5, 2009 at 10:36 pm
Just out of curiosity.....
What are you doing with this trigger by the way..?
September 30, 2009 at 2:35 am
if you want to script multiple job in 1 go, you can multi select the jobs and right click script using object explorer details view.
Thanks. Infact I was not aware...
September 25, 2009 at 7:38 am
There are multiple way of doing the same things...
I agree. You are absolutely right.
I just gave the solution which I thouhgt the most suitable for that particular question....
September 25, 2009 at 7:28 am
Please go through the below link as well
Don't know if it's of any useful for you. I have implemented in my DB.
September 25, 2009 at 7:08 am
I would like to backup all items that are created by myself: stored procedures, functions, jobs and -if possible- views.
Open SSMS
Right click on the database --> Tasks -->...
September 25, 2009 at 2:47 am
If database is not production. You can also use backup and restore with move option.
True. But that will leave you with 2 databases unnecessarily. The queston was to to move...
September 25, 2009 at 2:36 am
Hope you want to move MDF and LDF s of user databases.
-- Take Database offline
Alter Database TestmoveFile Set Offline
GO
-- Move the mdf and ldf files to new location using dos...
September 24, 2009 at 10:43 pm
Thank you somuch for the clarification.
September 21, 2009 at 6:07 am
Thank you all.
Actually am havng total 7+yrs experience in diff technology and domains. Now I decided to stick to SQL DBA (Almost 2 yrs exp in DBA). But now am...
September 17, 2009 at 3:01 am
I was a developer and got into DBA activities all of sudden (When one of our DBA left, I took over - I had knowledge on SQL Server development). As...
September 16, 2009 at 6:34 am
I was not confused at all. I knew the answer is 'OK'.
But I dint understand the relevance of this question.
September 16, 2009 at 2:55 am
Since you want to take backup from ServerB using script, Linked server must be the solution I suppose, as allready mentioned above.
September 1, 2009 at 11:27 pm
Thank you somuch.
September 1, 2009 at 5:40 am
Viewing 15 posts - 496 through 510 (of 707 total)