Viewing 15 posts - 10,486 through 10,500 (of 11,676 total)
Dave Ballantyne (1/13/2011)
Koen (da-zero) (1/13/2011)
January 13, 2011 at 6:27 am
Grant Fritchey (1/13/2011)
Koen (da-zero) (1/12/2011)
TheSQLGuru (1/12/2011)
I am curious what you mean by "advisor" here. Hopefully you do NOT mean Database Tuning Advisor!! Avoid that like the plague!!
Just out...
January 13, 2011 at 6:10 am
me_always (1/13/2011)
DisableEventHandlers property of DFT is set to false.
How do i find errors related to event handler? Rather I think, this is where...
January 13, 2011 at 5:23 am
Toreador (1/13/2011)
I use the one that is invoked by pressing F1 in SSMSms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/a87d0850-c670-4720-9ad5-6f5a22343ea8.htm#seeAlsoSection
No links that I can see. Maybe I'll switch to using the interweb version.
In the Help window you...
January 13, 2011 at 5:12 am
GilaMonster (1/13/2011)
Koen (da-zero) (1/13/2011)
Or do you deny access first to everyone and then give specific access to some resources?That won't work. Deny takes precedence over grant.
Hmmm, you are absolutely right.
I...
January 13, 2011 at 4:07 am
Are there errors in the data flow so that the event handler should be executed?
Are there any errors related to the event handler?
Is the DisableEventHandlers property of the DFT set...
January 13, 2011 at 3:58 am
Please read the link in my signature about needing a question...
January 13, 2011 at 3:54 am
Junglee_George (1/13/2011)
HiTry this useful link
http://beyondrelational.com/blogs/madhivanan/archive/2007/08/27/import-export-to-excel.aspx
:ermm:
Did you read the original question? The link you provided just explains how to import data from excel using the OPENROWSET command. The OP has already...
January 13, 2011 at 3:50 am
Adiga (1/13/2011)
IIS is a prerequisite for SSRS. If you do not want SSRS to be installed, you can safely ignore this warning. This does not affect installation the other services/components.
To...
January 13, 2011 at 3:43 am
At first sight they do indeed exactly the same.
I think it has something to do with how you implement your security model.
Are you giving everyone access first and then deny...
January 13, 2011 at 3:41 am
What are you trying to do? What are the errors that you get?
What is your actual question, because I don't see any.
By the way, there is a space between @...
January 13, 2011 at 3:33 am
Suri, if you were able to restart the SQL Server in single-user mode, your problem should already been gone away, as SQL Server drops and re-creates the tempdb when a...
January 13, 2011 at 3:29 am
gupta.sreekanth (1/13/2011)
can u tell me in detail .......how to do that one in ssis......
Sorry if this sounds harsh, but shouldn't you at least try it yourself?
All the people on this...
January 13, 2011 at 3:17 am
The expression language used in the derived column is not the same as using TSQL.
When in the derived column editor, look at the predefined functions at the top right.
January 13, 2011 at 3:15 am
irobertson has a valid point, there are enough (free) code formatters on the web. Personally, I wouldn't go through the hassle of creating all that code irobertson has written just...
January 13, 2011 at 3:13 am
Viewing 15 posts - 10,486 through 10,500 (of 11,676 total)