Thanks.

I'll look into it

We cannot make use of xp_cmdshell. It has been deleted from our extended procedures list for security reasons.

This is the error I get:

HResult 0x2, Level 16, State 1

Named Pipes...

we do have robocopy. The issue is to pass T-SQL declared and set variables to the SQLCMD. I just can't get the syntax right......

From SQLCMD to T-SQL is easy,...

First, your SQL Server version sould be at least 818, which is SP3a with MS03-031 patch (a MUST to protect yourself against the Slammer virus). Try that and see...

Second, my...

Talk about MS integration!!!!! (read MIS-integration)

I never would have known to look at this.

Thanks so much!!! it solved the problem.

There are rows in the table.

I can open the diagram from another WS, but not mine.

As I mentioned I re-applied SP3a with Security patch MS03-031. Did not work.

Do I have...

There are no scroll bars. We even played with the "zoom"

I would like to thank all of you for sharing your experiences with me.

It will help me in setting up the SQL environments on the SAN.

Thanks for the prompt response.

This would be the ultimate in regards to performance and I thought about suggesting it. I was looking for an alternative, if any, to this option....

quote:

---

When a user 'X' with dbo permisssion right-click on a table in the database 'AAA' and selects All tasks>Generate SQL Script in...

Okayyyyy, That's what I also thought....

I did a couple of tests. I hope my example is good enough. I ran a test where I retrieved the max(id) of a table....

I don't know whether this is worthwhile information but here it is anyways.

I've had problems with SQL Server whenever Exchange servers hosting the SQL mailboxes (we use several nt accounts...

quote:

---

I'm trying to setup up SQL Mail on a hosted server that is in a workgroup and not a domain. I...

I'd check out these articles:

MSKB 281208 and 327000.

Exchange 5.5 or 2000 needs to send messages as "itself", meaning the nt's mailbox name.

I encountered this problem when I started using SQL2K...

Is the mailbox for the WINNT account running SQL Server an MS-Exchange 5.5 or better mailbox?