Sorry for plugging my own product but I have developed what I believe to be the first 100% succesful spam solution...

Basically what we do is first of all check the...

Thanks for that, thats very helpful!!

Its very good to see that good response times are possible for that amount of data.

I am going to be re-structing my database.

mmmm.....

yes, i hadnt thought through the storage size issues yet! I think i shall have to re-think the structure. Alot of the data will be duplicated so im going to...

That is what i have suggested, the above code passes the XML as ntext (Unicode Text).

Dan

Yes, its a fairly easy job to get the data out in XML format from SQL Server, I would then pass it through an XSLT to meet the requirements (If...

If look up CONVERT in SQL Books Online then you will see there are a whole load of different formats you can convert the datetime value into. It is...

mmmm... good idea!

There are plenty of other sites for VB.Net, but i like the format of SQLServerCentral... Maybe i should create a VB.NET version? (Without infringing on SQLServerCentral of course....)

...

Just a quick one to check...

I had somthing similar and was having a load of problems finding out exactly what it was. Found it one night when I had...

you could write a stored proecure that uses the the syscolumns table to get a list of columns for a particular table

get the results of this query into a cursor...

if you want to allow your developers to setup DTS packages and SQL Manager scheduled task etc then they will need access to EM.

Think this depends on the size of...

if you are bcp'ing with a query then add...

getDate() as column_name as one of the selected fields.

Otherwise you can set the default value to the column to be getDate() and...

i knew they were gonna be bother!! they are using our XML interface (.NET & SQL 2K XML) with PhP!!

ok, found it on w3...

im write, customer wrong. For any reference...

http://www.w3.org/TR/REC-xml

2.2 Characters

Quote

[

Legal characters are tab, carriage return, line feed, and the legal characters of Unicode and ISO/IEC...

It will work with SQL 2000, but within SQL 2000. The only way you can use Java is as the access to SQL 2000. There is no way...

They can be used in SP's but don't think they can be used as parameters.

You have to delcare them within the body of the SP...

DECLARE @table1 table (a1 int, a2...