I am just not sure if the data what we are looking in SSC screen is the same he has in files. Sometimes SSC does magic tricks while showing some...

Posted Wednesday, May 21, 2008 9:55 PM

Please check for column separator. It looks like ‘ ‘(space) character is breaking the rows in multiple columns.

Divide it by 1000.

I forgot to mention T-SQL scripts. We will extend your existing code to meet your requirements.

To help you better, please provide us table DDLs, sample data & expected output.

What about operator precedence? If it needs to be calculated from left to right, it would be easy with string operations. Operator precedence will make it little complicated.

Please provide us...

Please start another thread for your issue. We will try to help you.

Posted Wednesday, November 03, 2010 12:27 PM

SQL Database Management Objects (SQL-DMO)

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

Getting Started in SMO

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

Script out a user from SSMS window, you will find necessary options in it.

What output you get when you type in following in Windows explorer?

\\192.168.14.25\d$

If it errors out, it’s a permission issue.

A JOIN query should work. First of all create a query to SELECT data from 3 different tables with fully qualified names. Then add INSERT statement to insert these rows...

I don’t see any harm in giving it (DNS changes) a try. Please let us know if it works.

I am sorry. I just overlooked it. As SSMS doesn’t appear in Express edition, there is no scope for argument on it.

You may try SQL CMD instead.