Viewing 15 posts - 1 through 15 (of 35 total)
sysobjects are system tables.. if u query systables u can see that these are system tables in 2005
August 28, 2009 at 8:07 am
you just execute master..sp_configure or
you can make use of server property..... function or
execute
exec master..xp_msver
March 6, 2009 at 12:39 am
you can make use of server property..... function or
execute
exec master..xp_msver
March 6, 2009 at 12:37 am
Many things I can suggest...
1) Identify the Need of While Loop as before Post
2) Find Order by Distinct all required
3) Please check why 100...
March 5, 2009 at 1:49 am
so u were not searching NoLock from syscomments...?
thats great..... what sql server u are using...?(for column Lock..)
March 4, 2009 at 11:53 pm
Hope both the server are of same configuration..?
March 4, 2009 at 5:43 am
so better u use a stored procedure in this case.
define the stored procedure in linked server and call it ...
March 4, 2009 at 5:36 am
what are the things u tried to bring this down...?
1) shrink the file?
2) restarted the server?
3) Detach the server?
4) Offline the DB?
March 4, 2009 at 5:29 am
varchar length u need to define;)
March 4, 2009 at 5:15 am
Please follow this link
http://www.sqlservercentral.com/Forums/Topic666390-145-1.aspx%5B/url%5D
March 4, 2009 at 5:11 am
Just curious to know...
how many objects there in ur DB...?
how much time it taken to execute this query..
March 4, 2009 at 5:04 am
what is the requirement to find the string from a package..?...
if u want to find the dts names there are system tables that are there in the MSDB Data Base.
March 4, 2009 at 4:56 am
when loose confidence... courage... and ... Patience
and surely need to be experienced...
March 4, 2009 at 4:51 am
1. Is there any OS Updates are happened
2. Any Virus Updated Ran...
3. Have you Executed any big Transaction in the sql server
January 29, 2009 at 12:05 am
Viewing 15 posts - 1 through 15 (of 35 total)