can this issue be resolved?

even if I have a red cross for the question, I strongly believe that I was right.

Can this be explained in detail, and in case you...

Instead of using select * from sysprocesses where program_name like '%ref%', use if exists(select * from sysprocesses where program_name like '%SQLAgent%').........do something

..........as of accessing the Servers, use Microsoft SQL Server Management Studio.......you will be able to maintain frequently used scripts on your local system, which can be used all across the...

First of all, if you have this option then plan it. We usually don't have this relaxation to migrate databases often. You will learn a lot, and people here at...

Use the following script -

USE master

GO

SELECT B.[Name] AS [Database Name (Logical)],

A.[Name] AS [Physical Name],

A.[filename] AS [File Path],

A. AS [File Size]

FROM sysaltfiles A

INNER JOIN sys.databases B

ON A.DBID=B.Database_ID

--WHERE B.[Name]='PRACTICE'

GO

Note: You can use...

You can also check-out the following links -

http://sql-server-version-control.qarchive.org/

http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1093178,00.html (nice one)

check out the following link -

http://www.sqlservercentral.com/articles/Development/2743/

You can know the location of the database files as well as their size, which is needed for monitoring, using the following script -

USE master

GO

SELECT B.[Name] AS [Database Name (Logical)],

A.[Name]...

Mohan is probably true.....stress brings in silly mistakes.....relax.....you know a lot and no one is going to kill you for a mistake....leave you seat and have a stroll every hour.....it...

For SQL Server, MS has come up with integrated source control in SQL Server 2008.......I think it is time to upgrade.....:)

Great Max....that was an exact answer.....thanks....it proved helpful for me....

You will not have any problem with prefix blanks, as the LEN function only trims the trailing blanks.....hope this helps

Use the following script -

DECLARE @StringVARCHAR(255),

@SearchStrVARCHAR(255)

SET @String='The quick brown fox jumps over the lazy dog'

SET @SearchStr='fox '+'////'

SELECT SUBSTRING(@String,CHARINDEX(LEFT(@SearchStr,LEN(@SearchStr)-4),@String),LEN(@SearchStr)-4)

Note: You can directly have the column name in place of the variable.

Does a RAM of this magnitude help in performance improvement?

Surely we don't need such a huge RAM to access memory locations, because the size of the storage devices and time...

If your intention is to setup a report database, I will strongly suggest the SQL Server Reporting Services....you will be overwhelmed by the features and things you are able to...