GSquared (12/4/2009)

Bob Hovious 24601 (12/4/2009)

I thought it was Lloyd Bridges.

Bru: Lynn is correct.

If I post something that...

In addition to the already listed options, try some freelance work. If you can get some freelance work under your belt you could add that to your resume.

Ratfink

Disappointment

Best of Luck Gus. Same sentiment as the others - sounds like a sinking ship to me.

Not exactly what you are looking for, but it is an alternative

http://www.bigresource.com/Tracker/Track-ms_sql-4rvFrQuz/

There is also the possibility of using SSIS to help send the proper codepage in your emails (through dbmail...

Yes. I have seen them try that with apps we bought being installed on my db servers. If you kick back hard enough, they will find a way...

In the Result Set tab set Result Name to 0 and select my System.Object variable (this will end up holding an ADO Recordset)

Gus made a great suggestion. In addition to the book, install it, configure it and play with SSRS to get a better understanding.

What happens if you clean out your temp dirs?

What happens if you change the system temp variable to point to a different location?

Try this previous SSC thread

http://www.sqlservercentral.com/Forums/Topic417928-148-1.aspx

In SSIS in your data flow task, add a data transformation task. Add a derived column.

http://msdn.microsoft.com/en-us/library/ms137630.aspx

http://technet.microsoft.com/en-us/library/ms190273.aspx

Add column with default

USE AdventureWorks ;

GO

CREATE TABLE dbo.doc_exf ( column_a INT) ;

GO

INSERT INTO dbo.doc_exf VALUES (1) ;

GO

ALTER TABLE dbo.doc_exf

ADD AddDate smalldatetime NULL

CONSTRAINT AddDateDflt

DEFAULT GETDATE() WITH VALUES ;

GO

DROP TABLE...

Agreed, more details will yield a better answer. It will depend on accounting software and the software platform.

Your best bet will be to research and find a tool that can do schema comparisons between the two platforms (i.e. redgate has one that will compare SQL databases for...

I would be extremely cautious of using that option. That option is for less than desirable configurations (i.e. quorum is on a shared resource with other drives) or for...