Viewing 15 posts - 7,831 through 7,845 (of 13,469 total)
Dave did you get this settled and working?
April 5, 2011 at 6:22 am
finding network objects like SQL installations is one of those things that's actually easier to do outside of TSQL.
I have used SQLRecon[/url] to discover all the servers on a given...
April 5, 2011 at 6:13 am
dave-dj (4/4/2011)
I'm trying to set up and SQL server trace using the create trace stored procedure. I generated the script in SQL Profiler and exported it.
In a...
April 4, 2011 at 12:32 pm
we need an evil version of "let me google that for you" that gives wrong answers.....it would be ideal for these situations.
April 2, 2011 at 5:21 am
you can use some DMV's to see what has been used since the last time the server was started:
if it's not on the lsit, it has not been accessed...but be...
April 1, 2011 at 12:33 pm
see this post that i did recently on creating a read only user that also could EXECUTE procs and functions;
http://www.sqlservercentral.com/Forums/Topic1084522-5-1.aspx#bm1084563
what you are asking is exactly the same, with one more...
April 1, 2011 at 8:53 am
hehe reminds me of that previous April fools day when they said that Red Gate was taking over SQLServerCentral.com...
April 1, 2011 at 7:06 am
to help you visualize, here's a prototype to review and get your head around it.
assume you added a CreatedDate column today to a specific table.
you restored a backup as suggested...
April 1, 2011 at 6:31 am
adding the column to every table, or the parameter to every procedure could be scripted from the meta data,but...
the procedures are the problem; every procedure has to be hand...
April 1, 2011 at 6:12 am
spin, yes, it's sounding like you need the specific drives;
as you were setting up , you saw there is a selection of some possible drivers, but when you connect to...
April 1, 2011 at 4:53 am
you want to use the OUTPUT Clause; it's especially helpful when you insert more than one row.
from what I've read recently, even SCOPE_IDENTITY() function can fail to return correct values...
March 31, 2011 at 12:35 pm
then you'll have to slow down, take a deep breath, and start identifying the objects/data they need to capture. call another meeting for exactly that: ask those who know the...
March 31, 2011 at 10:01 am
If you are not going to install SSMS for them, then something like LinqPad might work. It supports multiple languages, including TSQL, and it is a Decent SSMS replacement: it's...
March 31, 2011 at 9:57 am
this link shows another forums building a linked server to that type of db; it's got a description for both SQL Server gui settings and then a scripted linked...
March 31, 2011 at 9:50 am
can you exec sp_help fogos ?; isn't that FK already there? i think that;s what that error means.
March 31, 2011 at 8:17 am
Viewing 15 posts - 7,831 through 7,845 (of 13,469 total)