Good.

Exactly the same principle, except that the linked server process won't work. You'll have to search to find out whether it's possible to link to the local users and groups...

So local Windows account instead of domain accounts? Exactly the same principle, except that the linked server process won't work. You'll have to search to find out whether...

Suresh B. (1/31/2014)

---

Subrata Bauri (1/31/2014)

---

Actually I want to list out all the inactive users(windows) which are not able to login into the OS & henceforth they are not able to...

That information isn't stored in SQL Server. You'd need to set up a linked server pointing at your AD server, if your network admin will allow it.

John

Mark

I'm not sure what your point is. The question is about compressed databases (not compressed disks), as was my reply. I apologise if I didn't word mine clearly.

I...

I think you're assuming this question is more complicated than it actually is. What it's actually saying is this: "I have two databases that take up the same size...

Precisely. ...

OK, so fix that. When you set the value of a scalar variable, you can only pass a single value to it. If the SELECT statement you use...

You need to do it before, not after.

John

The first thing to try is to put a SELECT @ADR3 statement in just after you set the value of the variable. Then you can see whether the problem...

Happy to help, and I'm glad it turned out so well. Please will you share your solution, in case anyone else has a similar issue and wonders how you...

Jeff's and Lynn's queries return the last value, which, as was pointed out, isn't necessarily the largest. Depending on what the exact requirement here is, it may be worth...

I remember once having a conversation with the support team of another vendor of third-party backup software, and resigning myself to the fact that I was going to have to...

If you take a differential backup, you'll need the original backup as well. But yes, your differential is likely to be almost as large as a full backup. ...

You can write your stored procedure with a table-valued parameter instead of scalar parameters. You'd need to use an OUTPUT clause on your INSERT statement instead of relying on...