Viewing 15 posts - 31 through 45 (of 219 total)
You can’t copy the LDF file while the DB is online. You must take the database into offline and copy it to the tape....
February 4, 2004 at 6:01 pm
Oh this is what i am looking for. Thanks Brian
January 29, 2004 at 10:32 am
You can use XML Editor instead of Visual studio
January 27, 2004 at 1:53 pm
You can do it by configuring master-target server.
January 12, 2004 at 2:47 pm
I guess Steve is refereeing the Guest login ID in the msdb database. There is no way you can remove the public role. Public users access the DTS packages...
January 9, 2004 at 3:14 pm
By default public member can view/create/delete the DTS packages unless you deny the access to the procedures sp_enum_dtspackages, sp_add_dtspackage in the msdb Database. Only DBOs and sysadmins can execute...
January 9, 2004 at 2:08 pm
Depends on how big it is? Had a similar situation with one of my old client, table size is 30+GB. If you see any perf problems I would suggest take...
December 2, 2003 at 11:28 am
The file may be damaged or could be a disk problem. You are very lucky if only tempdb is on it, either you can move it to other drive or...
December 2, 2003 at 11:22 am
Yes you can specify multiple queries by separating with (;), but you’ll get the results merged in one file
November 21, 2003 at 12:14 pm
It's little tricky, for the regular INSERT/DELETE/UPDATE you can directly refer Select * from Linkedserver_Name.DB_Name.Usercontext.objects_Name. Whereas to drop the object you must use
Linkedserver_Name.DB_Name.DBO.sp_executesql N (‘DROP table <tabl_Name>’)
I figured it...
November 21, 2003 at 10:47 am
As Linda said, BCP is also another option in place of DTS
November 19, 2003 at 10:52 am
No direct way, but you can setup a DTS pack to generate a .xls file by specifying the same query and let sqlmail pick the file and email.
EXEC master..xp_sendmail
...
November 18, 2003 at 1:13 pm
What’s your main goal here, If you just want to ship the data bases I would just backup the databases and restored on other server and take care the logins...
November 17, 2003 at 4:41 pm
There is no way you can script the users and roles in the EM, unless you come up with a custom scripts. If the users are quiet a few I...
November 7, 2003 at 5:08 pm
1) Disable the job
2) Import the dates into a table
3) Develop a routine to call the job in a SP by checking the dates.
October 30, 2003 at 4:58 pm
Viewing 15 posts - 31 through 45 (of 219 total)