Viewing 15 posts - 16,261 through 16,275 (of 18,926 total)
Is the built-in administrator group still part of the sysadmin role??
you could change the authentication method in the registry and relogin that way, change, reset the sa password and you'd...
June 23, 2005 at 11:47 am
Cause I don't remember posting queries, or messages.
June 23, 2005 at 11:44 am
Maybe one quick optimization..
Select 1 from Table where 1=0
You still get a recordset but at least it's empty.
Then on the app side you only need to extract the return parameter...
You...
June 23, 2005 at 11:29 am
Do it client side... This is not a job that the server should be doing.
June 23, 2005 at 10:44 am
Just for the heck of shooting you down to make sure he never uses this crappy (performing) solution. ![]()
June 23, 2005 at 10:35 am
Hehe... could be worthwhile if you can have 10 jobs at the time
.
June 23, 2005 at 10:34 am
INSERT INTO tbl_a (col_A) SELECT cast(col_B as int) FROM tab_b where ISNUMERIC(Col_B) = 1
June 23, 2005 at 10:32 am
--for a single object
Select * from dbo.SysComments where id = object_id('ViewName') and text like '%whatever%'
--for any number of views (and what I suppose you are asking)
Select Distinct O.Name from dbo.SysObjects...
June 23, 2005 at 10:19 am
Can you post the trigger code too?
This can be optimized a lot.. should stop timing out.
June 23, 2005 at 10:16 am
Create a linked server to the database, then query like this
Select * from LinkedServerName...TableName (play with the number of dots if it doesn't work... never did that with access).
June 23, 2005 at 10:14 am
Check out my first post on this Thread (final update from (select))
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=189202
June 23, 2005 at 10:12 am
Nice resume there... Would like to see Joe Celko answer this one
.
June 23, 2005 at 10:03 am
Viewing 15 posts - 16,261 through 16,275 (of 18,926 total)