Viewing 15 posts - 1 through 15 (of 57 total)
Nice intro to a very complex field.
I particularly enjoyed your timeline image.
Another further reading book I would add for those who love...
August 10, 2005 at 2:08 pm
This was almost a good question about recovery processing. But due to the syntax error it just confusing nonsense.
I think the answer
A. "An error occurs because the first restore...
August 10, 2005 at 1:17 pm
Check out the T-SQL FOR XML clause in BOL. Also, check out the SQLXML stuff for creating XSD XML views.
Peter Evans (__PETER Peter_)
May 4, 2004 at 6:50 pm
Use ado streams if you are using ado. Should be a VB example readily available on msdn. You need to specify the dialect properties on the command object and instance...
April 8, 2004 at 12:10 pm
You can also use a TSQL variant of
sp_help_maintenance_plan @plan_id = 'your plan id value'
If you run it without a null value it will return a list of plans.
Peter Evans...
April 8, 2004 at 12:00 pm
smknox,
I use to work at a health care outcomes company, back in the mid nineties and XML was just in its infancy back then. Yet, they were already talking about...
March 25, 2004 at 10:46 pm
How is this kind of answer to this question really helpful to the SQL 2k certification crowd?
The goal is obviously somewhat achievable today since some many are doing it. ...
March 25, 2004 at 9:49 pm
Are you using the MSDA provider for ODBC data sources instead of the OLEDB provider for SQL Server. If so your DSN connection properties are probably the culprit check them out...
March 25, 2004 at 9:36 pm
xp_'s all run in context of the agent account.
Peter Evans (__PETER Peter_)
March 25, 2004 at 9:22 pm
When you run the job interactively the task will impersonate you and have your credentials when looking for the file.
When the sql server agent executes the job it will on...
March 25, 2004 at 9:20 pm
Are you sure your RS or COMMAND is not in adAsyncExecute mode?
You symptom sounds like your Find call is resulting in cancelling the .requery call. See relevant snippet from MSDN...
March 25, 2004 at 8:52 pm
All Item 2 states is that the @traceid is used as a output only value. SQL doesn't have true out only parameters. 2 says the sp will ignore the the input...
March 24, 2004 at 10:16 am
What about using the RAISEERROR statement in the wrapper proc bill suggested?
Peter Evans (__PETER Peter_)
March 24, 2004 at 12:27 am
You might also try using the timer function in your activex vbscript code and just loop until you reach a constant value of ticks set in the script.
Peter Evans (__PETER...
March 24, 2004 at 12:07 am
Barbara,
Extended stored proc run in the context of the SQL Server agent account which will either be the sysadmin or the proxy account if you set SQL Server agent up...
March 23, 2004 at 11:28 pm
Viewing 15 posts - 1 through 15 (of 57 total)