There is a senior who wants to replace all the inline sql statements with sprocs. Well fine, the application will stop looping through 1000 inline statements and now will loop...

"just in case we need it!"

Where/when would you let developers have SA privs?

Either way, as a DBA, you have to adapt. So how can you start changing? Go to one of your developers, or heck, attend one of their meetings and...

And when someone does successfully attack one of these places I wonder how many companies will get screwed when they finally read the T&Cs with a lawyer?

I don't doubt for...

If it is general blocking a set of users then a logon trigger will do the trick.

But if you want to block Server Admins & Developers with Server Admin rights...

Jeffrey Williams 3188 (4/29/2013)

---

Steve JP (4/27/2013)

---

Depends as the log file doesn't always want to shrink. If it doesn't then like I said a single file attach is a sledgehammer approach,...

Depends as the logfile doesn't always want to shrink. If it doesn't then like I said a single file attach is a sledgehammer approach, never said it was a preferred...

zi (4/25/2013)

---

Dear Experts

I have a 3 GB mdf file and 355 GB ldf file.

What should I do, I have taken a backup to the transaction log, should i delete the...

It looks like the driver you are using is for Excel/Access/FoxPro and not for text files.

When I have had to query csv files I have used the openrowset command...

yes we got that. But why do you want to change the names of the physical files????

ananda.murugesan (4/27/2013)

---

Hi,

what is wrong this code? pl. suggest

create table databaseSize (

DatabaseName varchar (100),

RowSizeMB varchar (50),

LogSizeMB varchar(50),

DBSizeGB varchar (50),

SteamSizeMB varchar(50),

TextIndexSizeMB varchar(50),

time_stamp getdate())

...

elham_azizi_62 (4/27/2013)

---

hello all.

i use this T-Sql for reading txt file:

select * from OpenDataSource( 'Microsoft.ACE.OLEDB.12.0',

'Data Source="f:\rahnama.txt";Extended properties="Text;hdr=no"')...rahnama#txt

but gets error:

OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "'f:\rahnama.txt' is not...

Without breaking anything?? I very much doubt it....

SQLKnowItAll (4/26/2013)

---

We have a situation where the business requires some ETL to be done throughout the day on a production database. One of the procs updates an xml column...

The ideal office??? Never having to work in one again! 😀

The main issue I have with large open spaces is that at times other teams, including helpdesks arent...