not sure what advice to offer yet, I've got a couple of questions first:

what was the specific error that was returned? that would tell us a lot.

how is the report...

the true instantaneous way would be a trigger, and your notification (email I assume) would have to be able to report if multiple rows were changed, as well as multiple...

Since you aready have a solution that is sending notifications due to change tracking, Instead of adding a trigger or service broker item to send an email immediately, i'd simply...

-edit: just saw Gail identified your logic as an Entiry-value table, and not a single table of similar values.

single table for sure.

That's a basic premise of normalization of your data:...

you want to think outside of the box on this one...literally.

you do not want to connect to a sql server simply to ask the sqlserver what it's IP is...since you...

jonas.kasper (4/30/2012)

---

It works fine allthough I couldn't use varchar(max)... Had to state a difinitive number (8000)...

Another question: How do I go about to start writing the text at line 7...

Simha24 (4/30/2012)

---

Hi Gail ,

In my CASE, All SQL Sever engine versions are same (4 nodes are running with SP3) where as client tools on 2 Nodes are running with...

it's easy...create the entire string as one variable, and then execute it via xp_cmdshell.

the issue is you cannot replace a variable with a concatination for most procs, like xp_cmdshell

it's prety...

Larry I'm not sure what you searched for.

drawing of any kind is going to have to occur outside of SQL server.

potentially, you could make a CLR to do the work,...

EXECUTE master.dbo.xp_cmdshell 'bcp "SELECT object_name(object_id) As TbLName,name as ColName FROM SandBox.sys.columns ORDER BY object_name(object_id), column_id" queryout C:\Data\Objects.txt -t"|" -c -T '

opc.three (4/26/2012)

---

It's a good idea to make sure Data Purity was run cleanly since the upgrade. The info is on the same page Gail pointed you to 😉

CHECKDB From Every...

awesome info Gail;

my db in question had dbi_createVersion = 539 in the code, which your link showed me was SQL 2000, sure enough.

Thank you very much! I added...

I think Lynn nailed it; In SSMs if you go to Tools>>Options

then expand SQL Server Object Explorer and select "Scripting", a form opens, and one of the options is "Script...

about the only thing i can find so far that implies a previous version in my sample system is in sys.databases like you pointed out, the previously "default" setting of...

very simiar to mine;

i put this proc in master, adn whenever i need to refresh myself with date conversions, i just run "sp_dates" in SSMs, to get a quickie preview...