Viewing 15 posts - 811 through 825 (of 1,079 total)
CASE 'January' when 1 etc?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 6, 2010 at 3:49 am
5 Years is intermediate, and there are still loads to experience from SQL Server, contribute and develop.
Next on your agenda I would say is to go for MVP status.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 6, 2010 at 3:42 am
Because the sql user account needs to be created on sql server level as well, not only db level.
drop the account from the DB, recreate it on sql server level,...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 5, 2010 at 5:39 am
sp_helpdb master or the database name
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 5, 2010 at 5:31 am
what type of account are you using to start the service?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 5, 2010 at 12:51 am
This should point you in the right direction...
http://msdn.microsoft.com/en-us/library/ms190737.aspx
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 5, 2010 at 12:16 am
You can run 2, to separate folders, one for backup purposes, and one for shipping to a remote instance.
BUT: when you need to do a restore, you'll need to use...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 4, 2010 at 11:37 pm
Hi Steve, I think "abandoning" VBS and PWS might be a bit harsh.
Moving on to new technologies is a definite yes, but still using your "legacy" knowledge is never...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 4, 2010 at 11:29 pm
You could use the same backup, although log shipping configuration deletes old logs after a set amount of time/days, just use caution.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 4, 2010 at 11:21 pm
something like this?
SELECT a.*
FROM OPENROWSET('SQLNCLI', 'Server=Seattle1;Trusted_Connection=yes;',
'SELECT GroupName, Name, DepartmentID
FROM AdventureWorks.HumanResources.Department
ORDER BY GroupName, Name')...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 4, 2010 at 7:27 am
try:
USE yourdatabasename
exec stp_yourspname
sounds like you are not focused on the correct DB where the proc was created.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
May 4, 2010 at 7:22 am
and that makes me more annoying.
you said it 😀
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 30, 2010 at 1:15 am
Are you trying to write multiple mark's into a single column, but not overwrite, just append next to each other?
or
Are you trying to write multiple rows for each student for...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 30, 2010 at 12:01 am
Thanx Mohan, I know, BUT - I need that list generated to be importable as a registered server list.
I dont want to build a manual registered server list.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 29, 2010 at 11:57 pm
Are you using SQL authentication?
then enable the password policy for that account,(but remove the tick from "user must change password..... and password expiration....")
and also see if its locked under status.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
April 29, 2010 at 11:43 pm
Viewing 15 posts - 811 through 825 (of 1,079 total)