Viewing 15 posts - 1 through 15 (of 15 total)
Thans for the notification. Please see the attachment.
February 25, 2009 at 8:44 am
As of now your log file is 10GB. So your 10% Growth will make the logfile grow 1GB more on every time it reaches its limit. Every hour it...
February 19, 2009 at 3:00 pm
You can give any file name which you prefer. Even the same filename is ok because you are changing the path.
You can verify the modification using sp_helpfile.
December 11, 2008 at 10:58 am
Go to object explorer
Choose the database --> Security --> Database Roles
Create New Database Role
December 10, 2008 at 9:12 am
is_ms_shipped - Object is created by an internal Microsoft SQL Server component., it will be 0 if you eliminate the constraint name during creation. So it won't be helpful in...
December 9, 2008 at 2:30 pm
Alter the table as the following to support the Greek character.
ALTER TABLE test1
ALTER COLUMN title nvarchar(200) COLLATE greek_ci_as
December 9, 2008 at 2:07 pm
You can add this in a batch file (.bat) to concatenate to a single file and use that for execution. For modification use the individual files.
December 8, 2008 at 3:08 pm
Are you sure
Object scripting options --> Include IF NOT EXISTS Clause is False.
I changed this to True then the Modify option used dynamic SQL, If it is false, uses...
December 8, 2008 at 3:00 pm
Did you try with the following menu
"Script Stored Procedure as" --> "Alter To" --> "New Query Editor Window"
December 8, 2008 at 2:41 pm
Open the second linked report in the report designer and choose the report parameter which should not be hidden, un check the Hidden property.
July 31, 2008 at 8:32 am
If it is encrypted, it should return 'The text for object 'sp_abc' is encrypted.' It should not return 'Object does not exist'
make sure the database you are looking is the...
January 14, 2008 at 12:19 pm
Yes there is an option for SS2005, but you should go through the MS visual studio 2005 team edition, go to Data Connections, connect to the server expand it, go...
January 11, 2008 at 3:03 pm
I am doing the transaction log for every 20mts. The first log is bigger than the full backup as I Quoted in my last post, after that all the trn...
January 11, 2008 at 1:46 pm
I have the same issue too... I did a full backup at 11:30, it has 34,994kb. after 5 mts I took a trn log backup,the size of it is 44,108kb....
January 11, 2008 at 9:52 am
Viewing 15 posts - 1 through 15 (of 15 total)