Koen Verbeeck (8/14/2014)

---

I asked Matt Masson...

DennisPost (8/14/2014)

---

I pregrow the files to an appropriate size (sounds like 256GB may need to be considered). But I avoid the multiples of 4GB and will go with 4000MB or...

Good to hear.

TomThomson (8/13/2014)

---

Good question. That's something we definitely agree on. sp_rename should update all the metadata. If it did, OBJECT_DEFINITION...

Evil Kraig F (8/13/2014)

---

Just an additional note on this: Any seriously competent sysadmin with physical access to the box, unless it has no interfaces (USB, CD Roms, etc), can...

lmarkum (8/13/2014)

---

We used backup exec and chose to back up with NTFS permissions. The other files we copied were from a machine also on SP1. Should we try...

Ok, that works for the registry settings. But the permissions for the service accounts on this other array...

Use a derived column

Try something like the following. Bear in mind that you still have the other transformation in...

curious_sqldba (8/13/2014)

---

Are there ways in SQL server to deny connecting to a instance? Basically i am looking for a way where data is accessed only through application , even the...

I was concerned about the windows accounts and permissions.

Were all the accounts, permissions and registry settings restored?

Eirikur Eiriksson (8/13/2014)

---

demin99 (8/13/2014)

---

Hi Iam using SQL Server 2012.I have around 120 packages deployed in Integration services catalogs.

I wanted to find the packages that uses a particular tablename. Is there...

Multiply by 100 in the source data instead of the format.

It also helps to understand what...

DennisPost (8/13/2014)

---

I know Kimberly Tripp[/url] does not recommend log growth using multiples of 4GB increments, but the bug explained by Paul Randal[/url] has nothing to do with crazy VLFs growing.

We...

moment of silence.