Viewing 15 posts - 91 through 105 (of 148 total)
Good catch, Lynn. Thank you.
May 11, 2012 at 8:34 am
Try this:
CREATE PROC usp_splitoutputfile
@tablename VARCHAR(200), @volume int,@Splits INT
AS
BEGIN
IF @Splits = 1
BEGIN
...
May 11, 2012 at 7:15 am
The sa account will always have a password. If you selected mixed mode auth during instance install then you would have been forced to create a password for sa. That's...
May 9, 2012 at 5:09 pm
GilaMonster (5/9/2012)
Thomas Stringer (5/9/2012)
GilaMonster (5/9/2012)
When you open SSMS, Run As Administrator.Why would it be running under the security context of SSMS?
It's not. The attach itself runs under the...
May 9, 2012 at 11:25 am
GilaMonster (5/9/2012)
When you open SSMS, Run As Administrator.
Why would it be running under the security context of SSMS? Wouldn't it be a permission issue with the SQL Server service...
May 9, 2012 at 11:09 am
You can use PowerShell to handle this. But if you are set on using it through SQL Server, then execute xp_fixeddrives across all of your servers and store that...
May 8, 2012 at 10:06 am
use YourDatabase
go
select
db_name(database_id) as database_name,
object_name(object_id) as sp_name,
cached_time,
last_execution_time
from sys.dm_exec_procedure_stats
where database_id = db_id('YourDatabase')
Change YourDatabase to the database name in question (don't forget the database name in the WHERE clause).
May 8, 2012 at 8:48 am
You don't need to use a subquery.
update client
set uniqueID =
SUBSTRING(lname,1,2)+ SUBSTRING(fname,1,2) +
replace(convert(varchar,dob,10),'-','')
WHERE uniqueID IS NULL
May 7, 2012 at 12:43 pm
If it is your shop's requirements and policies, then obviously you need to comply with that. There is no technical hard and fast rule that is needed though. ...
May 7, 2012 at 10:53 am
The problem isn't with SQLCMD. It's that the DDL CREATE VIEW and ALTER VIEW must be the only statement in a batch. And that is not the case....
May 5, 2012 at 4:52 pm
First I would call up the support of your TPV and ask them exactly what their definition of an upgrade is. It's surely not a higher version database backup.
The...
May 5, 2012 at 2:31 pm
Matt Miller (#4) (5/4/2012)
You might care to take a...
May 5, 2012 at 6:20 am
That's correct. Omit the flag and you'll omit the sparse attribute in the article, but not the column/data.
May 4, 2012 at 7:42 am
It's a bitmask for the @schema_option param. The value of the sparse switch is: 0x20000000000.
May 4, 2012 at 7:21 am
Viewing 15 posts - 91 through 105 (of 148 total)