Hi,

As to my knowledge there is no defined size of SQL Server Error Log file. Sql Server will keep on using the same file until the server is restarted or...

Dear Pramana,

Listed is the script taken from http://www.c-sharpcorner.com/UploadFile/67b45a/how-to-generate-a-create-table-script-for-an-existing-table/

I have modified it to omit the identity property.

DECLARE

@object_name SYSNAME

...

Why so serious...!! :crying:

Dear Akbar,

If it didn't solve your issue share the complete code and version of your SQL.

Also have you recently upgraded your SQL Version.

Saw a similar kind of thread on msdn...

Dear Akbar,

have you tried disabling and re-enabling the trigger?

Hi,

What i can make out of your requirement is listed below:

1. You want to secure your data.

2. You want to know who is accessing what data.

If my assumption is correct...

Old bad habits die hard...!! :blush:

Dear Gila,

I started the query with

Select Distinct(Left(Code,3)..... to check for the first three characters.

and then added the rest of the code.

Forgot to remove the Distinct. 😛

Dear Immaduddin,

Use the Below mentioned query

Select Distinct(LEFT(Code,3)) as CODE,COUNT(Name) as Name

From [TABLENAME]

Group by LEFT(Code,3)

Hope it Helps..!!

Hi,

For Scheduling backups to one or more then one designated folder you can use ola hallengren backup script.

https://ola.hallengren.com/sql-server-backup.html

If you want to move the backed up database to a new folder...

Check the last reply from the GilaMonster. 🙂

Hi,

Code in your batch file would be something like this:

C:\Program Files\Microsoft SQL Server\100\DTS\Binn\dtexec /f "c:\pkgOne.dtsx" /l "DTS.LogProviderTextFile;c:\log.txt"

# /f "c:\pkgOne.dtsx" refers to the location of the saved SSIS pacakage.

# /l "DTS.LogProviderTextFile;c:\log.txt"...

Dear Accidental Programmer,

Best of Luck..!! 🙂

Hi,

Another way to go about it is that you can change the recovery model of the database from Full to Bulk logged and hence Alter Index statement would be minimally...

No need for NOT IN clause 🙂

DECLARE db_cursor CURSOR FOR...