Viewing 15 posts - 181 through 195 (of 965 total)
Multiple users can use Developer Edition, you just have to have a Developer Edition License for each person. They are generally really cheap, like $50 IIRC. Your best...
January 5, 2010 at 10:18 am
David Portas (12/28/2009)
December 28, 2009 at 6:48 pm
Your connection string should look something like this:
connectionString="server=SERVERNAME;database=DATABASE;Integrated Security = true";
FILESTREAM requires that you use Integrated Security to work properly. Whatever Windows User your application is running under...
December 24, 2009 at 10:20 am
philcart (12/23/2009)
Great article Jonathan, looking forward to more. Especially interested in extended events.
Event Notifications and Extended Events are completely different animals in SQL Server. Extended Events are new in...
December 23, 2009 at 8:54 pm
Post the TSQL that you used to do this. Its probably just a single missing step in the setup you did. It should follow the instructions on the...
December 23, 2009 at 2:33 pm
Stan_Segers (12/22/2009)
December 22, 2009 at 3:00 pm
greggoble2 (12/22/2009)
December 22, 2009 at 2:55 pm
Jr or Sr, if you are responsible for SQL, this should be a concern that you raise, and be loud about it. Document the concern in an email to...
December 21, 2009 at 8:15 am
I don't know, looking at client statistics, which removes the SSMS overhead populating/display gridview data in .NET, the SQL 2008 appears to me to be faster. I think...
December 20, 2009 at 10:26 pm
I paid $599 for my Dell Insprion 1440 which has a 14.1" screen T4200 processor (x64), 4GB RAM but supports 8GB, and then I paid $300 for a 120GB OCZ...
December 18, 2009 at 11:02 pm
I haven't used it nor do I plan to anywhere in the near future, but just reading the descriptions, its typical of most SAN's, touting self tuning configuration and really...
December 18, 2009 at 7:51 pm
Hmmm... A number of factors here aren't equal, so its hard to say that it should perform the same. Which server has the faster CPU clock speed, front side...
December 18, 2009 at 7:33 pm
I am pretty sure that what you are attempting falls under dynamic assembly loading which is disallowed in SQLCLR for security:
http://blogs.msdn.com/sqlclr/archive/2006/10/18/dynamic-assembly-loading.aspx
Just because you can doesn't mean you should. This...
December 18, 2009 at 7:04 pm
simon.murin (12/17/2009)
CREATE PROCEDURE [dbo].[TestSendMail].....
WITH EXECUTE AS <account with rights to send e-mails>
Wouldn't it be easier that way?
Have you tried it without TRUSTWORTHY ON? It won't work for a number...
December 17, 2009 at 4:21 pm
It's not a stupid question and it is easy to miss even if you are reading through it. I just wasn't sure how to answer the question being asked...
December 17, 2009 at 1:37 pm
Viewing 15 posts - 181 through 195 (of 965 total)