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 |
a4u6178
Starting Member
11 Posts |
Posted - 2011-08-04 : 04:20:16
|
Hello enveryone, How can i make exec sp_tables accept database name explicitly..when i execute the exec sp_tables this query, it takes database name by defualt (current database) how can i make it accept database name as parameter. Thanks & Regards,Asif |
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-08-04 : 04:58:13
|
quote: How can i make exec sp_tables accept database name explicitly
It is a system stored procedure. You can't change it.You can write your own stored procedure or when execute sp_tables prefix it with the database nameexec [your database name]..sp_tables '<table name>' KH[spoiler]Time is always against us[/spoiler] |
|
|
a4u6178
Starting Member
11 Posts |
Posted - 2011-08-04 : 05:42:37
|
Thank You very much khtan. ur code snippet working fine for me..Thanks & Regards, |
|
|
|
|
|