Viewing 15 posts - 45,841 through 45,855 (of 49,552 total)
Look up ALTER TABLE in Books online and check the section on foreign key constraints.
You set the cascading properties when you create the foreign key. If the constraint is set...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 9, 2008 at 4:54 am
ltoso (7/9/2008)
do you mean to say i should shrink it to 27mb or something else the current size of transaction log shows as 27MB and which is also set as...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 9, 2008 at 4:50 am
That is the entire command. EXEC sp_cycle_errorlog
You can get full info on it in Books online.
I would suggest you cycle the error log, then watch the new log file to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 9, 2008 at 4:48 am
umailedit (7/9/2008)
What are "all the benefits that come along with it"?
The prestige of the title for one and the industry recognition that comes with it. I'd consider that one of...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 9, 2008 at 4:46 am
Those are SQL's latest 2 error logs. How often do you restart the SQL Service there?
Do you ever check SQL's error logs? I can't think of any reason they should...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 9, 2008 at 1:45 am
Please edit your post to fix the scrolling. use [ quote ] rather than [ code ] (removing spaces)
If the log is only 27 MB, leave it alone. It's small...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 9, 2008 at 1:39 am
You can, but you shouldn't need to. SQL only keeps a certain number of log files (default I think is 6).
Every time the service is restarted or the log is...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 9, 2008 at 1:21 am
ltoso (7/9/2008)
Hi,shrink file to 27mb(what should be mentioned here)
That's the option you want. To know how big to make it, you need to know how much space the log typically...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 9, 2008 at 1:17 am
You can do it through management studio. Go to the database properties and to options. It's at the top of that screen.
You can shrink the log file there also. Right...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 9, 2008 at 12:51 am
Those are .net errors, not SQL errors. Looks like you have a table missing.
Did the installarion give any problems?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 9, 2008 at 12:40 am
debraj.behera (7/9/2008)
You can create DTS in sql 2005 using integration services.OPen Visual studio 2005
File > New > Project > Bussiness Integence Project > Intgration Service Project
That creates an SSIS project,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 9, 2008 at 12:37 am
Set the DB to simple recovery mode, like all the others, then do a once-off shrink of the log (just the log) if it's larger than it's supposed to be....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 9, 2008 at 12:36 am
terry.jago (7/9/2008)
the back up the log with a no_log command
no_log is deprecated in SQL 2005 and not recommended for use. If log backups are not required, then just switch...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 9, 2008 at 12:17 am
ltoso (7/8/2008)
thanx for the fast reply, i am very new to sql server so can you help me further like
What is the recovery model for this database?
where can check this...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 9, 2008 at 12:03 am
Leave off the triggers. consider cascading deletes on your foreign key relationships.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 8, 2008 at 11:57 pm
Viewing 15 posts - 45,841 through 45,855 (of 49,552 total)