I still disacgree with this, that's not what i got from TheSLGuru's comments:

As...

it's the tablename: the table is not "testen.strasse", it is "testen" or "dbo.testen"

the code is looking for a schema testen and a table strasse, which does not exist.

ALTER INDEX strasse...

i think you'll have to have some ugly cleanups to try to find possible matches:

SELECT * FROM

(

Select PK,

REPLACE(

REPLACE(

REPLACE(

REPLACE(

REPLACE(

...

ok, as Seth identified, there's plenty of ways to script tables...GUI, SMO, lots of script contributions.

one of my articles out there is how to script a table via TSQL[/url]. by...

the why is easy; NOT IN requires it a comparison to each value in the sub-select.

really that is the same as saying :

WHERE GR.NumDoc <> 1

AND GR.NumDoc...

when you use NOT IN, you have to prevent NULLs in your dataset:

change query1 to this, and you'll get the expected resultsi think.

select GR.NumDoc As Query1 from GR Where GR.NumDoc...

sweet ! i was hoping to fiddle with that old thing after you...

she could install Enterprise edition again on the production server as a new instance, and not be out of compliance with the license, right?

if the server was beefy enough to...

ok so you are after more of a console application to run at the command line; still very doable in .net, but you need a lot of parameters, which can...

BLM I've got a .NET project that i built that, among other things, is my Developer Report Builder;

I was re-inventing the wheel to improve my own skillset, and created...

thank you for the feedback! glad it helped you out!

homebrew I've got an old script contribution out there that takes every trace file that happens to be in the same folder as the default trace, and imports it into...

i worked in a shop where someone turned off auto update statistics, and with only 20 users hitting with an application, the database ground to a halt in less than...

dsohal (11/30/2010)

---

Hello,

Thanks for your help, I guess it is going to help me, just couple of things, I am trying this in my development environment right now,

1- How I can...

glad i could help! i had to do a search to find the reference you were talking about, where we participated in a different getdate() post a couple of months...