Viewing 15 posts - 1 through 15 (of 106 total)
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...
Regards,
Shafat Husain
🙂
And Your Lord Never Forgets...!! (64:19 -- Quran)
February 26, 2015 at 2:13 am
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
...
Regards,
Shafat Husain
🙂
And Your Lord Never Forgets...!! (64:19 -- Quran)
January 4, 2015 at 11:39 pm
GilaMonster (12/30/2014)
No ORDER BY, no guarantee of order. End of StoryIf you need a particular order, put an ORDER BY on your query.
Why so serious...!! :crying:
Regards,
Shafat Husain
🙂
And Your Lord Never Forgets...!! (64:19 -- Quran)
December 30, 2014 at 1:40 am
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...
Regards,
Shafat Husain
🙂
And Your Lord Never Forgets...!! (64:19 -- Quran)
December 29, 2014 at 5:20 am
Dear Akbar,
have you tried disabling and re-enabling the trigger?
Regards,
Shafat Husain
🙂
And Your Lord Never Forgets...!! (64:19 -- Quran)
December 29, 2014 at 5:16 am
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...
Regards,
Shafat Husain
🙂
And Your Lord Never Forgets...!! (64:19 -- Quran)
December 29, 2014 at 2:19 am
Old bad habits die hard...!! :blush:
Regards,
Shafat Husain
🙂
And Your Lord Never Forgets...!! (64:19 -- Quran)
December 29, 2014 at 2:12 am
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. 😛
Regards,
Shafat Husain
🙂
And Your Lord Never Forgets...!! (64:19 -- Quran)
December 29, 2014 at 2:06 am
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..!!
Regards,
Shafat Husain
🙂
And Your Lord Never Forgets...!! (64:19 -- Quran)
December 29, 2014 at 1:40 am
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...
Regards,
Shafat Husain
🙂
And Your Lord Never Forgets...!! (64:19 -- Quran)
December 29, 2014 at 1:13 am
Check the last reply from the GilaMonster. 🙂
Regards,
Shafat Husain
🙂
And Your Lord Never Forgets...!! (64:19 -- Quran)
December 28, 2014 at 11:33 pm
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"...
Regards,
Shafat Husain
🙂
And Your Lord Never Forgets...!! (64:19 -- Quran)
December 28, 2014 at 11:30 pm
Dear Accidental Programmer,
Best of Luck..!! 🙂
Regards,
Shafat Husain
🙂
And Your Lord Never Forgets...!! (64:19 -- Quran)
December 28, 2014 at 10:59 pm
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...
Regards,
Shafat Husain
🙂
And Your Lord Never Forgets...!! (64:19 -- Quran)
December 26, 2014 at 3:55 am
DECLARE db_cursor CURSOR FOR
SELECT name
FROM master.dbo.sysdatabases
WHERE name NOT IN ('master','model','msdb','tempdb') AND name like ‘lcn%’ -- exclude these databases
No need for NOT IN clause 🙂
DECLARE db_cursor CURSOR FOR...
Regards,
Shafat Husain
🙂
And Your Lord Never Forgets...!! (64:19 -- Quran)
December 26, 2014 at 2:02 am
Viewing 15 posts - 1 through 15 (of 106 total)