When SQL server runs out of disk space, it stops and tells you it ran out of disk space...it doesn't automatically disable CDC, trace, jobs or any other service from...

can you change things like the connection string of the web application?

if you could get the web application to change the Application Name attribute on a per-page basis, you'd have...

you had previously said you had this setting "Be made using login's current security context" set."

The typical issues for linked servers tend to be related to which security context you...

Steve how good are you with programming?

I use this function as part of a larger ETL program i wrote; once I have a datatable, i can pass it to this...

if not too much time has passed, the default trace keeps track of DDL(CREATE/ALTER/DROP object changes)

the easiest way is with a report that exists in SSMS:

any chance of changing the schema? at least adding a column to be removed after the data transfer?

whenever I've done a data migration like this, I've always added a column...

what you want to do is wrap this up into a stored procedure, and use parameters;

here's an example of the code, and then how to call it: note the procedure...

Dave did you get this settled and working?

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...

dave-dj (4/4/2011)

---

Evening all,

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...

we need an evil version of "let me google that for you" that gives wrong answers.....it would be ideal for these situations.

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...

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...

hehe reminds me of that previous April fools day when they said that Red Gate was taking over SQLServerCentral.com...

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...