Viewing 15 posts - 1 through 15 (of 15 total)
When running queries against databases with large name, try referencing the databases in double quotes. Also, set quoted_identifier ON.
January 3, 2012 at 9:18 pm
Am sure the issue must be sorted by now, but still, just for future reference to others. You might consider this as well:
January 3, 2012 at 9:06 pm
It will help if you can share your partition specs along with script that you are using.
December 13, 2010 at 12:36 pm
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...
December 13, 2010 at 12:16 pm
I can do this. Please let me know if I shall go ahead.
October 29, 2010 at 11:50 am
You should be able to find them in C:\Documents and Settings\[UserName]\Application Data\Microsoft\SQL Profiler\[Version #]\Templates\Microsoft SQL Server\[Version #]
October 22, 2010 at 3:19 pm
Sorry, missed the link.
October 22, 2010 at 2:52 pm
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...
October 22, 2010 at 2:50 pm
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...
August 23, 2010 at 9:15 am
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...
August 23, 2010 at 5:44 am
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...
August 23, 2010 at 12:53 am
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. 🙂
June 10, 2010 at 12:44 am
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...
September 2, 2009 at 1:59 am
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...
August 22, 2008 at 5:47 am
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...
July 29, 2008 at 4:39 am