http://www.sqlxml.org/

This site has a lot of info on xml and SQL, one of the FAQ is how to get XML from SQL and gives an example using openquery...

SQL Profiler (2000) you can add the Audit Login and Audit Logout event classes.  This is more for a temporary monitoring. 

For permanant monitoring here is an article covering C2 Auditing. ...

In 2005 you can use the XML datatype, in 2000 you can use varchar(8000) if your xml is not greater than 8000 otherwise the text datatype can hold you xml... ...

Here's how to raise the error:  This assumes that empid 2 and 4 are static, is this the case?

IF NOT EXISTS(Select 1 from Books where empid in (2,4)) BEGIN

RAISERROR('EmployeeId 2...

Lynn beat me to it... but since I typed all this up I'll add it anyway...

Here is another for you:

-------------------------------------------------------------------------

-- FIRST WE NEED A TABLE THAT HAS ALL...

"Jason:  currently the random number is used as a multiplier, so has to be numeric.  I could change the logic, but the existing application gives the right results, so I'm...

If the need is for uniqueness and not keys you may want to consider timestamp datatype

This should give you a basic example of what you are looking for. 

---------------------------------------------------------------------------------

-- Just building dummy data

---------------------------------------------------------------------------------

if exists(select 1 from sysobjects...

It took some time and doing, but the solution was found using your first and second suggestion combined.  Thank you...

I had use a select .. into from statement and convert...

Does the account running SQL Agent have rights on the subscriber?

I'm not aware of any limit on the number of suscribers that can be added to an instance or publication.  As for performance, there will be issues regarding performance with...

Since the local table is my temp table this doesn't suck so bad.

I just did as you suggested and increased the length of the column to 80, 255, and 4000... ...

try

SqlConnection conn_1 = new SqlConnection("Data source=ServerName;Database=Touchpos SQL Server;Integrated Security=SSPI");

conn

or

SqlConnection conn_1 = new SqlConnection("Data source=127.0.0.1;Database=Touchpos SQL Server;Integrated Security=SSPI");

conn

What you want to do is a pivot with two columns of data.  SQL 2005 has a pivot function, search BOL for with pivot and pivot etc. 

If you are...

Not sure if this what you are looking for but here is a VB sample:

in T-SQL you would use convert in place of CDate and Cast/Convert in place of Cstr

August 22, 2006 at 6:40 pm