Surely you just need to add another backslash to your search pattern? I've removed the first wildcard from the front - you don't need it if all values start...

Your command doesn't specify which file to move. It just moves all .dat files either to the Error folder or the Processed folder. Of course, once you've done...

Yes, or if the table already exists:ALTER TABLE enrollment_in WITH CHECK

ADD CONSTRAINT CK_BEN_DENT CHECK (BEN_DENT IN ('Y', 'N'))

The WITH CHECK option checks existing rows for compliance with the constraint. ...

sunitkrishna (10/21/2015)

---

I tried to implement the function as given abovw.With the test data this is fast,but with the original bulky data,it is taking a lot of time.

Can anyone suggest where...

Thanks for the question. I realised that two of the options were mutually exclusive, so I had a 50% chance of getting it right - I picked the correct...

I'm wondering whether SSIS adds some stuff to the beginning of the batch - maybe SET statements or such like. MERGE requires the preceding statement to be terminated with...

Kathy

DNS aliases should work. You'd need to wait until the old servers were retired and removed from the domain before setting up the aliases with the same names.

John

If you don't parse the query, what happens if you then execute the package?

John

In SSMS, choose Registered Servers from the View menu. Register any server as a Central Management Server. Right-click on that server and choose New Group, and create a...

It'll be your WHERE clause. If you have any non-numeric values in any of those four columns, you'll get the error. Try this instead for each of the...

Sunitha

Three steps:

(1) Use a splitter function (search this site to find one) to split the elements of your strings into rows

(2) Write a SELECT DISTINCT query to eliminate the duplicates....

Please will you post the execution plan?

Do you have any control over the table structure? Is it really necessary to use nvarchar (instead of varchar) everywhere?

Why are you dumping...

Is that the job history or the backup history? What do you get if you run this?

SELECT

backup_start_date

,backup_finish_date

FROM msdb.dbo.backupset

WHERE type ='D'

AND database_name = 'MyDatabase'

Is the database in Full recovery...

Does your maintenance plan just do a full database backup, or does it take a log backup, rebuild the indexes and/or run DBCC CHECKDB as well?

John

Wow - I've never been offered a job where my salary in five years' time is written into the contract!

Sean's right - it's your decision to make. But make...