Viewing 15 posts - 6,331 through 6,345 (of 9,244 total)
jared-709193 (10/24/2011)
This is a SELECT ... from a view in which they used a TOP and ORDER BY.
are you saying the view definition is created upon a select statement...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 24, 2011 at 9:26 am
don't forget to set the rollover option too, by default it scripts out to zero which means no file rollover. This puppy catches a lot of people out. Also be...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 24, 2011 at 8:58 am
if you're unsure, use a server side trace for a week or so to monitor user connections before decommissioning
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 24, 2011 at 8:22 am
dajonx (10/21/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 24, 2011 at 8:09 am
Brandie i have seen similar to this before, what is the recovery model of the database, if full do you take transaction log backups of this database?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 24, 2011 at 7:15 am
PhilipC (10/23/2011)
I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 24, 2011 at 7:09 am
If you're having troubles with other external connections you may use the following to start sql server single user mode and only accept a connection from SQLCMD
sqlservr -c -m "SQLCMD"...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 24, 2011 at 4:42 am
database user permissions are held in the database itself. You only need to ensure that the server login SID matches the database user and this si what sp_helprevlogin does
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 23, 2011 at 1:33 pm
vino5786 (10/23/2011)
I have configured the Logshipping -Copy Job (Which copies tran logs from Primary Server) to copy all the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 23, 2011 at 1:28 pm
Yes you do! 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2011 at 6:19 pm
muthukkumaran Kaliyamoorthy (10/21/2011)
No no detach/attach is not good option to move the database from one server to another server. It has lots of disadvantages.
Such as??
You could also take the database...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2011 at 6:18 pm
As comprehensive as my article is, It takes longer than a couple of days and a forum guide to become proficient with windows clusters 😉
Most of the people on here...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2011 at 5:55 pm
open MS iSCSI Initiator and go to targets tab, make sure that all paths are connected. Are you using MPIO for the iSCSI targets?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2011 at 11:33 am
the command line parameters are used to start the sqlservr.exe for the particular instance you are fixing
Check services.msc for the location of sqlservr.exe for your chosen instance.
Open a cmd prompt...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2011 at 10:46 am
mvillar (10/22/2011)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2011 at 10:40 am
Viewing 15 posts - 6,331 through 6,345 (of 9,244 total)