in connections container there is a function called createStatement().

Use it to issue SET QUOTED_IDENTIFIER ON

It happens to me when i have 20 different apps running

so after that I started using undocumented sp_readerrorlog which also allows you to search error logs.

Here is the syntax...

http://www.sqlservercentral.com/scripts/Transfer+Logins+Administration/69245/

geramkumar (11/1/2010)

---

Good Morning All

I am a SQL Server DBA with bit .net developmet background. I manage 5 SQL Server 2008 R2 Instances.

My thought is to setup centralised monitor of 5...

This works:

http://deepakrangarajan.blogspot.com/2008/01/forgot-sa-password-in-sql-server-2005.html

Boris-615127 (10/27/2010)

---

Hi There,

I have Server that Has a lot of inserts going trough "sp_executesql" and some of them fail with

Msg 2627, Level 14, State 1,...

it would look something like this:

do not run this on production since it was just written and never tested.

you can have a static table but in this case it's a...

I would create a stored procedure which starts with getting data into sql server from excel:

SELECT * INTO XLImport5 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=C:\test\xltest.xls', 'SELECT * FROM [Customers$]')

then add the rest of...

truncate your tran log and in datapump change "insert batch size" to 25,000.

Also you should set your recovery model to bulk-logged during high volume of inserts.

WayneS (9/9/2010)

---

(And yes, I have ad hoc query enabled.)

I'm trying to export some data into an excel spreadsheet. This is actually being run through an SSIS package. Because the column...

AKP (9/8/2010)

---

Hi Guys,

I have a question regarding logshipping refresh on SQL 2005.

Here we have a logshipping configuration(Primary & Secondary) with Monitor Server. The secondary database is in restoring mode. Since...

dallas13 (8/31/2010)

---

Hello, This morning deveploers complained that they are not able to select data from one particular table in DEV Env. only 2 developers. their select query was runnning and...

did you update stats after partitioning?

also you can use index hints:

select * from table_name with (index(index_name))

Great confusing question.