a really awsome TSQL based stored procedure already exists for handling database backups is part of the suite here :

http://ola.hallengren.com/

that solution is peer reviewed and award winning, and...

ok for me the fix is easy;

there's a much better, award winning, peer reviewed and rather famous script to help handle things like reindexing.

it's been deployed by more businesses, on...

the microsoft documentation is here:

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

from what i remember, two way replication must be between non-express versions(SQL Express cannot be a distributor?), so i think you need to create both...

well, linked servers may not behave the way you expect;

typically here's what happens:

every row in the remote table is copied to a table in tempdb.

the update is performed on...

well, i think the issue's in the procedure you are talking about ...i don't think it's schema aware;

i wouldn't take the error message from the scheduled job literally(that a...

i think the table might be in another schema, but you are assuming it's in the dbo schema, since that's what is your default.

try this instead...what schema does it really...

where's the query you are refering to? did you forget to paste it so we can help you?

here's a tested example;

I've created a spreadsheet that has the contents of sys.servers.

you can grab a copy of it here:

SysServers_Example.xlsx

and the code, assuming 64 bit SSQL 2008 with the 64...

BCP only does raw text files,...

here's an xp_cmdshell example, like John mentioned above.

the list of files, isntead of being a single file, can be a space delimited set uf multiple files.

--http://www.7-zip.org/download.html

--http://downloads.sourceforge.net/sevenzip/7za920.zip

--xp_cmdshell is limited to ONE...

Hybrid DBA

Accidental DBA

😀

ok, adding WITH SCHEMABINDING to my scalar function cuts half a second off of my performance, so it goes to 7.5 seconds or so instead of over 8 seconds.

DelimitedSplit8K...

ok Dwain, I love these performance tests.

here's a setup comparing my crappy scalar function to your solution.

the DelimitedSplit8K pivot was roughly 4x faster on a million rows: 8 seconds vs...

patelmohamad (10/16/2012)

---

Thanks Lowell for instant reply,

This is my predication, not the actual data

, actual data is differ from my Example

in my data it gives me lot of no's 1,2,3.......n or...

the trigger is using the base table, isntead of just the new rows that exist in the special virtual tables INSERTED AND DELETED

this will insert just the new rows:

CREATE TRIGGER...