I found the example difficult to follow. To demonstrate the technique you could use one table with one WHERE without XML processing that is not easy for entry-level developers and...

Murali,

If you have many tables where data have to be replaced nightly then maybe you may have a second database same as the production one, import data there, count rows, do other...

Did you specify Remove Files Older Then .... on the Transaction log Backup tab of maintenance Plan too?

I don't think you can do it on the Back End unless you write code.

Your design should include a field for the origin of the record, like a foreign...

This is the easy way:

exec

sp_MSforeachtable ' select ''?'',count(*)  as NumberOfrecords from ?'

if you want you can insert results into the temp table and...

Debbie,

Sorry, had a busy day yesterday.

I think that the problem with #y may be here. Your Drop Table statement is inside the WHILE loop so after the first pass the...

I would say it is an ARGUMENT. The article in the link refers to parameters only in regards to SqlParameter.

Got It. I got the same error message when testing @query line, I uncommented print @query and found where I got it wrong:

Change @query like this:

set

 @query ='BULK...

One of the suggestions may be to install Express out-of-the box and get the installation SW to copy a database file to its location and then run a couple od...

Hi,

The picture would not show, please post the message in words.

Also, I had to upgrade 6.5 database last year and we did have problems running 6.5 on Windows 2003. So...

Check who is executing.

When you execute DTS package then it is your SQL Login who is executing the job. If you are an admin in SQL Server (for example your...

If it is a CRM and uses attachments it may require Integrated for this part. I am running one of the industry-leader CRMs that uses SQL Server authentication but attachments...

Just Because 🙂

No real difference, this is a matter of preferences.

Scott is right, This is the easy way to create a temp table with the same fields as another table.

Debbie, WHERE 0 = 1 means that since 0 never equals 1...

Hi,

You should post this question on ASP or ASP.NET forums.

To answer some of your questions:

3. under C:\Inetpub\wwwroot folder check if any of these exists: index.html, default.html and other default...