Viewing 15 posts - 3,826 through 3,840 (of 7,503 total)
Has the account that launches the ssis package been granted read authority on your UNC path / file ?
(service account of sqlagent or proxy account of the sql jobstep that...
April 10, 2009 at 5:33 am
It is as useful as putting a fence around your house.
Anyone wanting to walk on your territory will have to do a bit more effort to get there.
So, maybe they'll...
April 10, 2009 at 1:13 am
Basically, with a migration scenario, you install a fresh sqlserver (not necessarily on a new box) of the edition you want to migrate to, and then you copy the databases,...
April 10, 2009 at 12:41 am
We install SSMS + BOL on every sqlserver server.
(BIDev studio will only get installed at request.)
Why do we install SSMS locally on the server ?
Because we are only allowed to...
April 10, 2009 at 12:21 am
I advise to use Gerts solution on SMTP mail to avoid all the hassle with the mail client.
Have a look at http://www.sqldev.net.
It will off course need an extra step to...
April 9, 2009 at 12:15 pm
HTH
Just make sure you test it (so you get to see the lovely pictures as desired) 😉
April 9, 2009 at 7:17 am
you could determine the max number of parts (e.g. 3) and write a left join statement to concatenate the 3 columns.
SELECT T1.FileData + coalesce(T2.FileData, '') + coalesce(T3.FileData, '')
from...
April 9, 2009 at 5:52 am
also check SSC (this site) for scripts "split function".
April 9, 2009 at 5:43 am
Eswin (4/9/2009)
Hi while creating the view you can use CHECK_OPTION to prevent insert and update option.Check out the example:
http://www.rampant-books.com/t_super_sql_129_check_option_view.htm
from BOL:
CHECK OPTION
Forces all data modification statements executed against the view...
April 9, 2009 at 5:32 am
Krishna Potlakayala (4/6/2009)
ALZDBA (4/6/2009)
San (4/6/2009)
Somehow I managed to install SQL2k5 with different instance name and logged using "machineName\instanceName". Now another problem is that, when I select " " option...
April 6, 2009 at 7:45 am
San (4/6/2009)
Somehow I managed to install SQL2k5 with different instance name and logged using "machineName\instanceName". Now another problem is that, when I select " " option in SERVER NAME...
April 6, 2009 at 7:17 am
For SQL2008 also have a look at Brians overview at http://www.mssqltips.com/tip.asp?tip=1714
April 6, 2009 at 2:58 am
Maybe Lynn Pettis can give you some nice advice regarding usage for schools.
https://www.sqlservercentral.com/blogs/user/Profile.aspx?UserID=13138
April 6, 2009 at 12:53 am
Thank you for the feedback.
April 6, 2009 at 12:38 am
Igor Makedon (4/3/2009)
Could you please help me with my problem:
Given:
Login: pacrat
User: pacrat with default schema: [pacrat]
view pacrat.tv (as select getDate())
BOL states that under these circumstances query...
April 5, 2009 at 11:55 pm
Viewing 15 posts - 3,826 through 3,840 (of 7,503 total)