Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ann06
Posting Yak Master
171 Posts |
 Posted - 2008-03-24 : 06:47:00
|
| In SQL 2000 porfiler i want to replay a trace but its replaying in differnet DB hw to choose the database? there is only option to choose the server and not the database to run at !!! so the result always giving error objects not found!!! |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-03-24 : 07:09:33
|
| You can set default database for the login you are using to replay trace using sp_defaultdb. This way whenever you connect to the server using given login, SQL Server will open the default database specified.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
|
|
|
Replaying a trace not able to choose the database