You can ask this que at

http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=19&SiteID=1

You can do this after installation also if you missed do this while installation.

In management studio Goto server property --> Database setting --> Database default locations

You can add second server as linked server and an query using full reference name of object like servername.databasename.schema.object

Thanks Mark,

I have read about this function but never thought to use for IP manipulation. 😛 I...

This script will give you path

DECLARE @s-2 VARCHAR(100)

SET @s-2 = 'D:\backup\databasename\Backupname.bak'

SELECT SUBSTRING(@s, 1, LEN(@s) - CHARINDEX('\', REVERSE(@s)))

If proper transaction are...

Try this

CREATE TABLE #T (DT DATE)

INSERT INTO #T(DT)

SELECT '2009-01-01' DT

UNION SELECT '2009-01-10'

UNION SELECT '2009-01-12'

UNION SELECT '2009-01-08'

UNION SELECT '2009-01-22'

UNION SELECT '2009-01-16'

UNION SELECT '2009-01-14'

UNION SELECT '2009-01-26'

UNION SELECT '2009-01-06'

SELECT DT, DATEPART (WK,...

Replace this with

IF NOT (ISNULL(@ingredient, '') = '')

Try this

DECLARE @s-2 VARCHAR(100)

SET @s-2 = 'D:\backup\databasename\Backupname.bak'

SELECT SUBSTRING(@s, LEN(@s) - CHARINDEX('\', REVERSE(@s)) + 2, LEN(@s))

Hey,

Try this

DECLARE @s-2 VARCHAR(100)

SET @s-2 = '192.168.0.27'

SELECT SUBSTRING(@s, LEN(@s) - CHARINDEX('.', REVERSE(@s)) + 2, LEN(@s))

1. It depends upon the usage of the variable. If you use same variable, many times in sp then better to use variable, instead of sub query each time. And...

You can use below query as well

select user_id, name from

(

select row_number() OVER...

Sql Server also have ROW_NUMBER function, but it does not give you the storage order. You can use this function is select query by specifying the retrival ORDER.

For which purpose...

Hi Grant,

I have tried to search for article (MUD), you have mentioned but not finding naything. Can u pls post some details, so that I can find the article?...

If temp database uses more space then it might help to increase the storage. Check for the usage of the temp DB.