Code page problem. Did one of the servers have a patch applied?

We use an automated process to continually restore 10 minute logs to a DR site for many databases. The process is really a stored procedure that runs from a control...

With 35K rows (1000 pages!) I would definitely have an index on it. How important the index will be depends on how big the table is, what kind of data...

collect whatever you can, hopefully you can set up a filter to trace only activity from this login and against the database involved in the queries.

So the next step is to look at windows System/Application/Security logs to see if any entries correspond with these process executions. Also set up a trace and try and capture...

Try it and see how it works. I've done similar things myself but you will never know how or if it will work until you try.

Sounds like it might be one of your SQL Agent jobs. Is your SQL Agent service running as a real local or domain user account or just local NT authority...

Setting a var-whatever (which is what an XML column is) column to NULL does not suddenly shrink the row down by the amount of bytes the column was consuming. It...

GBeezy (7/8/2013)

---

Chris, Thanks for the reply, but why would I need to check the firewall settings, when I can run the old SPROC that hardcodes everything (it works fine) and...

Gathering data across different databases and/or servers does not require that everything take place in one single transaction... unless I am missing something. That is why I was interested in...

It appears that all of this dynamic SQL is running in one giant distributed transaction across however many SQL servers are in your sys.servers table. For one thing, I...

You could try this:

select * from YourTable where isnumeric(YourColumn) = 0

this will at least show rows that are not in proper numeric format. ISNUMERIC can sometimes be fooled but its...

You can use a DataAdapter and call the update method, OR write a small loop to loop through the rows in the table and do an insert on each...

You would be amazed at some the things we see from programmers when left to their own devices.;-)

They...

bulk insert into a staging table, then do a single insert from the stage table into destination table like this:

open symmetric key ... decryption by certificate ...

insert into secret(id,ssn)

select id,...