Viewing 15 posts - 30,136 through 30,150 (of 39,763 total)
The above post was an advertisement, so it has been removed.
We do not take advertisements in our forums.
December 25, 2007 at 8:51 am
Please do not cross post.
Check here: http://www.sqlservercentral.com/Forums/Topic436236-17-1.aspx
December 25, 2007 at 8:48 am
You can't create a dynamic stored procedure like that. You would need to specify each variable:
create proc myproc
@a1 int = null
@a2 int =...
December 25, 2007 at 8:47 am
Merry Christmas!
And I don't think I've been doing this long enough!
😉
December 25, 2007 at 8:39 am
You can alter a stored procedure from a client by submitting an ALTER PROCEDURE statement. You can do this within a stored proc by using dynamic sql.
December 24, 2007 at 4:53 pm
The maintenance plans runs as a job, so you need a job reporting system.
You can query the msdb database on each server in multiple ways, script a connection to each...
December 24, 2007 at 4:52 pm
If that doesn't work, you can try these guys: http://pwcrack.com/sql.shtml
December 24, 2007 at 4:48 pm
You can save them out as VB packages and then perhaps write something to dig through the code, look for various tasks/connections, and provide some rough idea of complexity.
Most packages...
December 24, 2007 at 10:10 am
I'd pick up any of Itzak Ben-Gan's books on T-SQL. That will help.
December 24, 2007 at 10:08 am
You will need some scripting to identify the file and change the package to import it. Check http://www.sqldts.com for some ideas.
Also, please post in the appropriate forum.
December 24, 2007 at 10:08 am
The big one is probably being sure indexes are ok and statistics are up to date.
December 24, 2007 at 10:06 am
I think this is still being debated and I'd be comfortable with either approach as long as it was documented well. The call from the script package means you have...
December 24, 2007 at 10:05 am
Shrink the files, and then be sure that you are backing up the log periodically. A database backup is not enough.
December 24, 2007 at 10:01 am
The error log will display percentage of recovery if it's moving slowly. It is possible you have some redo or undo action that eats up log space. What was happening...
December 24, 2007 at 10:01 am
Viewing 15 posts - 30,136 through 30,150 (of 39,763 total)