ObjectID is unique within database.

Same ObjectID could exist in every database.

You should keep DatabaseID in the filter.

What do you mean when saying...

About string concatenations:

http://xkcd.com/327/

🙂

After you've changed the schema all procedures used it must be recompiled.

Their binary code becomes irrelevant, and so their dependencies.

When those SPs will be executed next time optimiser will evaluate...

Utsab Chattopadhyay (10/10/2007)

---

The server looks good and job is runnable only. (Via sp_who2 active)

Do u think killing the sp id will be a good dicission? Then I will drop all...

There is "ObjectId" in the list of Filter options.

Yes, it's possible.

But you need to grant administrative privileges to the account running SQL Server on all client machines. Existing and not compiled yet.

And you must make holes in all...

I don't see any question about T-SQL.

Theo Jacobs (10/9/2007)

---

Does anyone know what / how you would get the actual username used to logon to windows for the workstation firing the sql?

HostName and IP not sufficient for...

I believe it was about reading dates from files.

Unfortunately there is no unified way to pass date-time values in files, so we need always to agree on some format used...

SET DATEFORMAT ymd

You obviously have DATEFORMAT set to "dmy", so it reads '2007-10-03' as 10 March 2007.

If you can change format of dates in files to YYYYMMDD (no dashes). 20071003...

You welcome.

Yes, you probably need to spend more time clicking on things in those tools.

It's really worth exploring.

🙂

In Query Analyzer press F8 (unless Object Browser is already open), expand your database, click on "User Defined Data Types".

Mark Fyffe (9/28/2007)

---

Please provide some general guidlines on whether it is better to represent in a D.B. a fields for Year, Month, Day or is it better to have a...

Did not try "INSERT INTO OPENQUERY", but "DELETE FROM OPENROWSET" works perfectly in my application.