I can think of two places you should look. The first query is for the database file locations and the second query is where the dll's are located.

SELECT SUBSTRING(filename,1,1)...

I think you are looking for something like this...

select text from sys.messages where message_id = 101 and language_id = 1033

Open the Maintenance Plan In Management Studio and at the very top there is a little icon that looks like two reports (right next to Manage Connections). Click the icon...

Try this.

SELECT CONVERT(VARCHAR(10),CAST(date_id AS DATETIME),101)

FROM Summary_D

Also, what data type is date_id?

Try this...

Select

SUBSTRING(physical_name,LEN(physical_name)- CHARINDEX('\',REVERSE(physical_name))+2 ,LEN(physical_name))

FROM sys.master_files

I think the default trace that is running in SQL Server will capture this information.

--Run this query to get the current file name and place it in the path for...

Here are some scripts I use to show the jobs and thier related schedules. You should be able to use this to see how the tables are related.

http://mssqltips.com/tip.asp?tip=1622

This might help get you started. Notice that longer views are broken into multiple lines.

select B.name, A.text

FROM syscomments A

JOIN sysobjects B

ON A.id = B.id ...

I was about to ask the same thing as Gail. Here are some things you should do when upgrading...

--Update Statististics with Fullscan

Exec sp_MSForEachTable 'Update Statistics ? with FULLSCAN'

--The following...

Resample is a good idea to make sure you don't overwrite the full sample by the index rebuild. You still may end up doing duplicate work, depending on how busy...

...

I think you are talking about something like this. I just used 5 records in the example. Also, what version of SQL are you running?

--Begin Test Data

DECLARE @tbl Table(id varchar(10),...

That is because SQL is converting the string to a datetime so the datatypes are compatible in the case statement. If you convert the date to a varchar, the...

Yelena Varshal (5/22/2009)

---

This is a special character.

There are 2 workarounds in BOL:

http://msdn.microsoft.com/en-us/library/ms179859.aspx

Read in this page under these subtitles:

Using Wildcard Characters As Literals

Pattern Matching with the ESCAPE Clause

Let us...

I cut and pasted the first box and got this to work.

Declare @Table Table (tst nvarchar(100))

Insert into @Table Values ('"3C3Z*8620*BC[m[H[" ')

Select * from @Table

Where tst like '%%'