When running queries against databases with large name, try referencing the databases in double quotes. Also, set quoted_identifier ON.

Thanks.

_________________

Am sure the issue must be sorted by now, but still, just for future reference to others. You might consider this as well:

http://sqlcat.com/sqlcat/b/technicalnotes/archive/2008/08/09/moving-large-amounts-of-data-between-oracle-and-sql-server-findings-and-observations.aspx

It will help if you can share your partition specs along with script that you are using.

See if you wish to consider for:

- version and patch level details for OS and SQLServer

- data and logfile locations

- Key backup recover schedules, backup locations and backup device specs...

I can do this. Please let me know if I shall go ahead.

Regards,

Vikas Rajput

You should be able to find them in C:\Documents and Settings\[UserName]\Application Data\Microsoft\SQL Profiler\[Version #]\Templates\Microsoft SQL Server\[Version #]

Vikas Rajput

http:\\ionsql.wordpress.com

Sorry, missed the link.

http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/d1018ddb-8e04-43a2-a539-4245c90a0588

Hi,

There can be multiple situations when this error can pop up. It would help if you can add more details like

- if this is first time you are accessing this...

Its not very clear why you are looking for this information. Is there any underlying issue, or you are just looking for this information for reference purposes?

Anyways, you would need...

I have experience in SQL Server 2005 Production environments, and on Oracle as well. You are right to anticipate that SQL Server shouldn't be having any other applications. AntiVirus retains...

I personally would go with option #1. Reason include that your system is an OLTP system (with considerable size), and I have seen how heavy tempDB operations can deteriorate the...

Good Article. Thanks for sharing it.

I have used systeminfo in past, but generating a CSV with help of flags is an excellent idea. Makes to my personal command repo. 🙂

What is your purpose of your client meeting?

Are you a DBA, or a Developer?

Do you have to worry about any dependent applications or you can be completely DB...

Hi,

Did you mentioned for "DISABLENETWORKPROTOCOLS=0" at time of Installation of MSDE on your machine/server. If not, then you wont be able to reach your server instance over TCP/IP or Named...

Probably below is what you are looking for.

Script to capture uptime of SQL Server:

SET NOCOUNT ON

DECLARE @crdate DATETIME, @hr VARCHAR(50), @min-2 VARCHAR(5), @days VARCHAR(5)

SELECT @crdate=crdate FROM sysdatabases WHERE...