Viewing 15 posts - 30,181 through 30,195 (of 39,819 total)
If you have a log reader and you haven't been running in simple mode, then you can read the transaction log (live or backup) with one of the tools from...
December 26, 2007 at 9:50 am
I don't think you need local system admin privileges, but as mentioned above, you need coordination and assistance from the people that do. There are times you will have to...
December 26, 2007 at 9:47 am
Not sure that will work SQL_ORacle. You still need an account that has rights to connect to SQL Server as an administrator.
The account starting SQL Server has access, or should,...
December 26, 2007 at 9:44 am
We is the site. Sorry, thought it was fun and obvious.
December 26, 2007 at 9:42 am
The migrate jobs part is not easy and probably can't happen in a stored procedure. The backup could work, but it would need to have access to the remote sql...
December 26, 2007 at 9:41 am
Look up datediff in Books Online. It takes two parameters (dates) and a scale (day, week, etc. ) and returns the number of the scale in between the dates.
select (d,...
December 26, 2007 at 9:37 am
I'm not sure how this works or if I understand what you're asking. please be a little more clear and give a bit more information in the question.
Are you asking...
December 25, 2007 at 6:01 pm
Santa's all out of prizes for now.
I'm going to try Ultimate rather than hassle with XP too much for now. Slightly worried about drivers and I don't want to waste...
December 25, 2007 at 5:55 pm
In 2005, Configuration Manager. I think it's also in the error log and possibly the Windows Event logs.
You can do a netstat -a and look for the listener. I think...
December 25, 2007 at 4:48 pm
What's the error? I think you want "use databasex go alter proc xxx ..."
December 25, 2007 at 4:47 pm
Dedicated is a better word than sick 😛
Actually it's such a habit for me and since the desktop and office are mere steps from the kitchen, garage, and family room,...
December 25, 2007 at 4:46 pm
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
Viewing 15 posts - 30,181 through 30,195 (of 39,819 total)