Viewing 15 posts - 15,346 through 15,360 (of 22,219 total)
You can update views, but there's a whole slew of restrictions around it. These are straight from the Books Online:
Any modifications, including UPDATE, INSERT, and DELETE statements, must reference columns...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 26, 2010 at 1:15 pm
Cool. Glad I could help.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 26, 2010 at 1:07 pm
I guess I'm confused, the job_id is right there along with the next run datetime. What else are you looking for?
If you need a literal breakdown of the schedule,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 26, 2010 at 1:02 pm
Here's an explanation of the basic support schedule [/url]for Microsoft products. If you dig around on that site you can find the various products you're interested in. For example, here's...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 26, 2010 at 12:55 pm
This is right in MSDB: dbo.sysjobschedules
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 26, 2010 at 12:50 pm
striker-baba (4/26/2010)
That was apt solution for my problem..
I changer the recovery mode to simple and back to full and it worked gud..
one of my friend suggested me to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 26, 2010 at 12:48 pm
I am very confused by this code.
I'm going to take a shot at what you're trying to do, but I don't understand why you're doing it.
Are you attempting...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 26, 2010 at 12:30 pm
itskumar2004 (4/26/2010)
Well i am trying to create a view in which there are two variables @a and @b-2 which will be coming from date table ,now how can i...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 26, 2010 at 11:32 am
It kind of depends on how much data we're talking about. If you're speaking of millions & millions of rows each month, you should look into setting up partitioning for...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 26, 2010 at 10:54 am
You can't pass parameters to a view, so you'll have to answer Lynn's question in order to get any help. I don't understand what you're trying to achieve either.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 26, 2010 at 10:49 am
Generally approaching something like this I would create three different processes. They won't "talk to each other" but the log backups on care that there has been a full backup...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 26, 2010 at 10:47 am
TRACEY-320982 (4/24/2010)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 26, 2010 at 7:39 am
One thing you might want to look into, with 500 DTS packages, is a product called DTS Exchange[/url]. We've been using it and having very good luck with it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 26, 2010 at 7:38 am
You really need to identify what's causing the issue. One thing that does occur after an upgrade is that the statistics for every index are rebuilt as they are accessed....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 26, 2010 at 7:36 am
Yep, I agree. Some time of network event, possibly a change in permissions? Hard to tell. Follow Lynn's advice.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 26, 2010 at 7:35 am
Viewing 15 posts - 15,346 through 15,360 (of 22,219 total)