GilaMonster (10/21/2011)

---

Move them back where they should be and offline/online or ALTER DATABASE ... MOVE then offline/online....

Hate to say it this way but, it depends. Keep this in mind, every byte of data you send to the client costs time and bandwidth. So yes,...

JamesMorrison (10/21/2011)

---

Elliott Whitlow (10/20/2011)

And sending you boss' boss an email, thats usually a last resort, it is rarely received well. You might have a conversation with that person if...

Wonderful news, glad to hear it.

CEWII

GilaMonster (10/19/2011)

---

No. Never ever detach a suspect or recovery_pending database as it will not always reattach (suspect will never reattach)

Are you absolutely sure that file is there? Exact path, exact...

I had a boss that would "kill or die" for his staff and he got strong loyalty and people busted their butts for him. I also had a boss...

WMIExplorer:

http://www.ks-soft.net/hostmon.eng/wmi/index.htm

CEWII

You might look at: http://sqlserverpedia.com/blog/sql-server-bloggers/simple-series-ssis-import-column/%5B/url%5D

CEWII

Because the file will need metadata, it is not a source, you can use any source, the component I mentioned is used in the pipeline between the source and the...

If you are talking from a file very likely. But since you are in 2005 I can't remember if the Import Column task is available in the Data-Flow. ...

amy26 (10/20/2011)

---

I would be careful about lying when you tell them your salary. This bit me in the *** recently because I found that some employers are now requiring...

Well Amy, I congratulate you on your new position. I hope it is everything you wanted. And a pay raise never hurt.. I have to say that...

I would create a variable, probably at the package scope to hold the date/time.

I would use an EXEC SQL task to do a MAX of the field in question. ...

Perhaps this is why mainframes aren't used as much anymore.. The spirit of cooperation was absent..

CEWII

I had a ghost rollback a couple weeks ago, it was in the killed/rollback state and kept reporting that it was 4% complete, but the time kept rising, when I...