GilaMonster (1/10/2014)

---

Why are you trying to shrink it? Surely if the database is 95% full (there's almost no free space left), you'd be looking to grow the database (make more...

tt-615680 (12/2/2013)

---

Dear All,

I have to take a mirrored database 'offline' but I would need to bring them back on line at some point. Is the best practice to remove the...

3nrico (1/7/2014)

---

Some extra information I just found out:

Whatever I try to do the file simply won't grow past 2,097,152MB which happens to be 2TB exactly.

Does anyone know of a possible...

Seems like one of the node is removed from the cluster, normally, you should escalate this to windows folks, if you are not a cluster expert.

You should add the node...

george sibbald (1/7/2014)

---

backward compatibility. I expect Microsoft used the term 'deprecated.'

Microsoft are giving you a chance to wean yourself off OSQL. expect it to disappear at some point. Its still...

george sibbald (1/7/2014)

---

SQLCMD did replace OSQL so you should use SQLCMD if you can. However OSQL should still be there if you have installed SQL2008

You would find it in c:\program...

I just read that "with SQL2005 osql and isql have been replaced with SQLCMD"....is this true? please advise.

Lowell (12/30/2013)

---

you can get the date an object is created from sys.objects create_date and modify_date.(tables/procs/views etc)

you cannot get when a permission was granted. that date is not stored anywhere.

if...

Lowell (12/30/2013)

---

you can get the date an object is created from sys.objects create_date and modify_date.(tables/procs/views etc)

you cannot get when a permission was granted. that date is not stored anywhere.

if...

Thanks.

MohamedDBA (11/24/2013)

---

Are I can spread my database filegroup files to more than storage drive , not on the same storage drive , and stay connected logically as if they in...

GilaMonster (11/20/2013)

---

You can just add the new file (with a decent size) and disable autogrow on the first one. With an empty new file and an almost full existing one,...

Why don't you just script out the tables you need and apply at destination?

anoop.mig29 (9/25/2013)

---

Hi friends

i know this is stupid question but i wanted to know why isn`t backup allowed on database that are in restoring mode or that are in standby...

Ok, thank you.