Hello Tony,

In order for you to recover a database to a point in time, you need the following backup files:

1. Weekly full backup file

2. Last Differential backup file

3. Transaction log...

Hello Jim,

You can write it as follows:

Select @PartDescription = Description, @UnitOfIssue = UnitOfIssue FROM dbo.PartMaster WHERE PartNumber = @ComponentPartNumber

Thanks and have a nice day!!!

Hello Bill,

Check out "SET NOCOUNT" in BOL.

Thanks and have a nice day!!!

Hi Chris,

Do I need to take the differentials for the system databases too (if so, since we can’t take a diff on Master, do I...

Hello Dandrade,

Look into BOL (Books Online) for

logins-SQL Server, sp_change_users_login

and also sp_helplogins

Thanks and have a nice day!!!

Hello Sunder,

You can also try this query in Query Analyzer

SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

also go through this webpage from Microsoft

http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185

Hope this is helpful to you.

Thanks and have a nice...

Hello Seemita,

You can find out the details by using @@version in Query Analyzer as

Select @@version

which will give you information as

Microsoft SQL Server  7.00 - 7.00.1063 (Intel X86) 

 bla bla bla

Now based...

Hello Papillon

go thru this link

http://www.sqlservercentral.com/forums/messages.aspx?forumid=23&messageid=166060

Hello Minh,

From BOL:

REPLACE

Specifies that SQL Server should create the specified database and its related files even if another database already exists with the same name. In such a case,...

Hello Arun Kumar,

Have you gone through the BOL (SQL Books Online) topic "TextCopy - Handling text and image data". if you click on samples, there are examples provided.

Hope this might...

Hi G MOney,

Replace the above code with the following:

Declare @idoc  int

Declare @xmldoc  varchar (2000) --- you haven't specified the size

set @xmldoc = '

<?xml version="1.0" encoding="utf-8"?>

<ArgentinaInputFile> --- you have placed an...

Hello Santhosh,

Every log file in a maintenance plan will be suffixed by a timestamp data. So you can go ahead and create the required maintenance plan. Even you can check...

Hello Peter,

Thanks for the clarification but my dept head writes

If you can force the Autogrow to happen at a 15% free space threshold I’m okay with that ..   we had...

It is not showing the growth physically in the properties when checked in EM. The management wants to have a 30 gig increase. So how can I work out.

Thanks

Hello Enthusiast,

Thanks for the reply. Can you be more specific with the command to be executed?

alter database

name = 'logical name',

filename = 'path of physical filename',

size = ????

maxsize = ????

filegrowth =...