Viewing 15 posts - 13,831 through 13,845 (of 22,227 total)
To do that properly, so that the user doesn't get access, you need to open up a programming language, VB, C#, whatever, and create an executable.
Otherwise, a simple solution would...
"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
December 8, 2010 at 5:46 am
Unless you've done modifications to it (in which case, you really should have a tested backup around that you can restore from) model is generic. Do you have another instance...
"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
December 8, 2010 at 5:44 am
GSquared (12/7/2010)
Steve Jones - SSC Editor (12/7/2010)
Brandie Tarvin (12/7/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
December 7, 2010 at 12:30 pm
vinothraj (12/6/2010)
...Naturally it will join based upon the order you have given...
No, not at all. The natural behavior of the optimizer is to rearrange the join order, right out of...
"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
December 7, 2010 at 5:43 am
I hated geometry, so don't look at me. But even if someone could write the function in TSQL, they shouldn't. It's not something that the T-SQL language is going 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
December 6, 2010 at 9:24 am
I guess I'm still confused as to what you're going for, but sQL Server knows which databases it uses to maintain itself. It works with them and there's very little...
"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
December 6, 2010 at 8:14 am
Yep, what Steve said. Sorry I wasn't clear. It's a domain account that I was describing without saying it properly.
"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
December 6, 2010 at 8:13 am
No, SQL Server should run as an account on your system that has access to that drive. We usually use a common service account for most of our systems, but...
"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
December 6, 2010 at 7:34 am
Why do you care? What are you trying to do? If Paul White's script here doesn't do the job, what is that you're looking 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
December 6, 2010 at 7:32 am
shaun.turner (12/6/2010)
So I don't usually post my problems on these forums as I tend to prefer to find the answers myself but this one has me stumped and I'm...
"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
December 6, 2010 at 7:22 am
Size could be an issue in the decision, but I'd look to complexity. If the import is extremely simple, just a column mapping, I'd use TSQL to do it. If...
"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
December 6, 2010 at 6:50 am
I don't completely understand what you're trying to do here. SQL Server backups should be run from within SQL Server using the backup syntax:
BACKUP DATABASE X TO DISK = 'some/location'You...
"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
December 6, 2010 at 6:48 am
Luke L (12/6/2010)
Grant Fritchey (12/6/2010)
GilaMonster (12/5/2010)
I've only got 7 plugins in...
"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
December 6, 2010 at 6:39 am
GilaMonster (12/5/2010)
Don't go for tonnes of plugins. Get ones you really need (like syntax highlighting), add more as the requirements arrive.I've only got 7 plugins in total.
I'm running with 4...
"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
December 6, 2010 at 5:32 am
Jeff Moden (12/5/2010)
Heh... I found a way around all of the "problems" with WordPress... I write articles on SQL Server instead of blogging. 😛
You may be on the right side...
"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
December 6, 2010 at 5:30 am
Viewing 15 posts - 13,831 through 13,845 (of 22,227 total)