I think you'll have to check with them to know what specific format they expect before we can give you much of a code...

ahh...but WHICH Julian format do you want?

from lurking here on the forums, I've seem three different styles;

for example

109252 = in AS400/DB2 date is 01/01/1900 + 109 years +...

TRUNCATE can be prevented if a FOREIGN KEY exists to the table,so you could create an empty table with a FK constriant to the tables you want to protect from...

i think this is my "final" version of the script; hope this helps you:

--Reverse_Engineer_database_Mail_Settings.sql

USE msdb

GO

Declare @TheResults varchar(max),

@vbCrLf CHAR(2)

SET @vbCrLf = CHAR(13) +...

and yet another way..this doesn't return the "hidden" servers denny identified; just the items that are advertised via SQL browser, i think.

this is how to do it in .NET using...

yes, except for the passwords used for the mailserver's AUTH command; those are in a CREDENTIAL that I've never figured out how to script out yet;

however the rest of it's...

dallas13 (4/28/2011)

---

okay thanks for the reply but when I ran the same script 5 times after 5 minutes interval, it overwrite the files every time.

Here is what it says,

WinZip(R) Command...

i think the double quotes have to be around the entire path to the wzzip.exe file, not just *part* of the file name:

declare @cmd varchar(2000)

select @cmd

= '"C:\Program Files (x86)\WinZip\wzzip.exe"' +...

you didn't mention it, maybe it's there but not in the snippet you posted, but where is the connection for the dataadapter?

I know the ADODBRecordSet As object is the 4th...

can't you connect with your default linked server to oracle, and then simply switch to 4 part naming conventions, same as SQL?

That's absolutely true in my case whenever i connect...

SQL Server is deny by default, so as long as the user is not tied to a sysadmin, you would add the user to the database, and then add that...

SQL Server Compact Edition databases are supposed to a good idea for mobile phones and other portable devices;There's no service like SQLServer...

Syed Jahanzaib Bin hassan (4/23/2011)

---

lets try with recent updates of this release like service packs and CUs

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP...

here is an example that works to 99999.99; from there it's trivial to expand it to higher numbers:

--1,23,45,67,890

ALTER function lakFormatting(@value money)

returns table

as

return

SELECT

CASE

...

Isn't this handled by the GUI/app you are using to display the data? Typically separators are handled by the regional settings in windows for me; all numbers in SQL server...