Viewing 15 posts - 8,116 through 8,130 (of 9,241 total)
Your welcome!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 4, 2010 at 5:32 am
darth.pathos (4/2/2010)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2010 at 9:48 am
GSquared (4/2/2010)
You can grant the right to create procedures specifically.Would look like this:
GRANT CREATE PROCEDURE TO bob;
if granting the rights granularly as GSquared posted, just bear in mind that you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2010 at 9:33 am
Hi
cant speak for SQL 6.x or 7 but certainly from 2000 on the default of 0 is 100% thats what i have understood and read.
Yes you probably want to change...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2010 at 9:29 am
Paul White NZ (4/2/2010)
One real-life experience was of running a 2000-only application in compatibility mode, which failed because occasional batches included the *= outer join syntax.
I too have had...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2010 at 9:24 am
especially ensure the first thing you do after restoring or attaching the database to SQL Server 2008
is to run
DBCC UPDATEUSAGE
see the following link
http://msdn.microsoft.com/en-us/library/ms188414.aspx?ppud=4
you may have to leave the compatibility level...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 2, 2010 at 6:39 am
paulc.byrum (3/26/2010)
SQL Server 9.0.4035 (SharePoint instance)
SQL Server 8.0.2055 (Standard edition)
SQL Server 8.0.760 (MSDE)
SQL Server 9.0.4053 (Express Edition)
The...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 1, 2010 at 11:22 am
paulc.byrum (3/31/2010)
sqlcmd -E -d master -S \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
and then:
ALTER LOGIN [PBTF\Group - IT DB Admins] WITH DEFAULT_DATABASE = master
No errors running the command, but I still see Error 4064 in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 1, 2010 at 11:17 am
Hi Shawn
yes, as previously mentioned you need to have the paper proof which normally the DBA doesnt have access to (only the admins or bean counters 😉 ). If the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
April 1, 2010 at 11:14 am
Hi
you could use the following but as already mentioned it will probably not be helpful as paper proof is the norm now
select serverproperty('Licensetype'), serverproperty('Numlicenses')
However these details can be entered onto...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 31, 2010 at 11:24 am
Jeffrey
i understand exactly where you were coming from.
All
From BOL
However, if the old log file is not found and if the database was shut down cleanly and has no active log...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 31, 2010 at 5:47 am
SQL Server should really be installed after the computer name is changed, having said that
check the following link from MS
http://msdn.microsoft.com/en-us/library/ms143799.aspx
ensure each clone is prepped properly (new SID and computer name)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 30, 2010 at 10:47 am
Hi
only if you install SQL Server 2000 does it have to be a default instance and must be installed first before SQL Server 2008. Otherwise it doesnt matter. As Paul...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 30, 2010 at 10:27 am
Hi
the following is a great little utility I use for managing and extracting reports, etc from SSRS
http://www.sqldbatips.com/showarticle.asp?ID=62
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 30, 2010 at 10:21 am
Hi
you may also want to post this in the appropriate forum in future
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 30, 2010 at 10:13 am
Viewing 15 posts - 8,116 through 8,130 (of 9,241 total)