Viewing 15 posts - 4,741 through 4,755 (of 7,187 total)
Why would you delete a contact just because he has the same first name as another contact? If you insist on doing this, create your foreign key constraint with...
February 3, 2012 at 9:15 am
Profiler will capture (the whole of) every statement executed on the server, subject to any filter placed on the trace.
February 3, 2012 at 7:24 am
You don't. You link it to SQL Server at the same time that the web page is running. That way you can capture the SQL that is being...
February 3, 2012 at 7:10 am
OK, so you need to turn it into a stored procedure. You need to use dynamic SQL to build the query, a bit like you were doing in the...
February 3, 2012 at 6:39 am
As I understand it, you can't shrink the files smaller than the size of the model database, but you can shrink smaller than the creation size of the database if...
February 3, 2012 at 5:31 am
No, that's the errors you get if you run it from SSMS. You said you were running it from a web page. I think you need to ask...
February 3, 2012 at 5:18 am
In that case, you ought to check with your DBA.
John
February 3, 2012 at 5:14 am
My programmer boss gave it to me...Considering he has 20 years of experience I was hoping it would work!
Maybe it would if it were run from the right place -...
February 3, 2012 at 5:12 am
Depends on what you're trying to achieve. Where did you get the VB code from? If it's a question about how to compile VB code so that you...
February 3, 2012 at 4:42 am
Well, something has got a lock on your master database file. Maybe you or someone else are trying to open it in a text editor, for some reason? ...
February 3, 2012 at 4:38 am
Looks like you're trying to run a VB script through SSMS.
John
February 3, 2012 at 4:34 am
OK, so Integration Services is running under NT AUTHORITY\NETWORK SERVICE? Does that have access to SQL Server, either in its own right or through something like BUILTIN\Administrators?
John
February 3, 2012 at 4:29 am
Does your server name really have a "v" at the end, or is there a type in your config file?
John
February 3, 2012 at 4:22 am
A few more questions. Can you connect to the database engine through SSMS? You say you're on SQL Server 2008 R2. 32 bit or 64 bit? ...
February 3, 2012 at 4:14 am
Sounds as if it's something to do with the MsDtsSrvr.ini.xml file. Maybe it did get confused by what you did with the named instance. Are you able to...
February 3, 2012 at 3:59 am
Viewing 15 posts - 4,741 through 4,755 (of 7,187 total)