Hi,

You can do that in .NET or VB.... Just use FILESTREAM methods to read that file. Use some predefined text pattern in the file and replace in your...

Hi Steve/Red Gate Publishing Team/Simple Talk/Memebers,

It's a happy moment! Good that 1 million people are much interested in enhancing their SQL Server...

Hi,

Let me put it this way...

Server Name : SQL001

Instance Name: SQLSRV

Running since: 15 days

Now I connect to the server using Management Studio and run below query

"SELECT *...

oh.... that was a big type error... I have edited my post... Thanks for that...

Actually I was trying to say that after restarting SQL Server now it is visible...

Hi Jack,

Buy my case is SQL Server Agent is running but the entry is not there in sysprocesses...

For viewers who are checking this post for ORA-12154 error,

Incase you are

1. able to connect to Oracle from SQLPLUS

2. tnsping also works

3. Linked Server also works

but but...

4. Connecting from...

Hi Viji,

Goto Explorer and Select Tools --> Folder Options --> View and make a tick on below two items

1) show hidden files and folders.

2) Hide Protected Operating System Files

This will...

Hi,

From your post's I can understand that Reporting application was fine earlier and now you are getting into performance problems. So my suggesstion is,...

Hi,

You mean, you just want to connect to SQL 2000 and SQL 2005 Instances from Windows 98 right? If so then you need to...

Hi Guru's,

Is there any whitepaper or document released by MS which will help SQL DBA's to understand the best practice for which RAID to...

Are you trying to get Client Host Name from the past records?

Then you may need to try Log Reader to see which clients connected at that time....

Incase you are looking...

Hi,

Try enabling below Trace Flags

DBCC TRACEON(3213, 3605, -1)

to Log any Exception message and much more detailed information about the backup process in the SQL...

This error indicates that the destination path to which you are taking backup does not exist or the account used to connect to the path (SQLSERVER AGENT SERVICE A/C.) is...

If you have time and willing to learn in-depth then you can download this 7 Mb Article which will give you complete picture for your question....

http://www.microsoft.com/downloads/details.aspx?familyid=3D5E96D9-0074-46C4-BD4F-C3EB2ABF4B66&displaylang=en

Hi,

When you are taking backup, overwrite the full backup to same .bak file... Then you will not have two backup files. Will it help?