Viewing 15 posts - 4,936 through 4,950 (of 5,394 total)
-I have authentification windows comme nom du serveur and I would import my database to a server created by mine.HOW SHALL I CREATE A NEW SERVER?
You can create a new...
August 11, 2009 at 6:25 am
If the application was designed for MSSQL I don't think it will run on MySQL. It could, but I don't think it will.
The same applies to the web server: if...
August 11, 2009 at 6:09 am
Duplicate post.
Add your replies to this thread:
http://www.sqlservercentral.com/Forums/Topic768480-146-1.aspx
August 11, 2009 at 6:05 am
I had the same issue with AS/400 and I noticed that mostly depends on how the provider is loaded.
I suggest you load the provider out of process and always use...
August 11, 2009 at 6:04 am
If you are running an ASP.NET application, I guess the application is the only thing accessing DB from the host machine, so you could simply set up a profiler filter...
August 11, 2009 at 5:56 am
... or Spaceball's Barf (Barfolomew for the formal ones)!!
August 11, 2009 at 4:56 am
I could aspire to be Chewbacca at most...;-)
August 11, 2009 at 4:54 am
Probably it won't fix anything, but I usually run stored procedures with ADODB.Command objects.
At least I'm sure it maps variable types correctly.
If you want to trap what happens inside the...
August 11, 2009 at 4:44 am
This works for minimally logged operations, such as BULK INSERT.
For "normal" inserts the operation is fully logged.
BULK LOGGED recovery model does not allow point in time recovery.
BOL recommends backing up...
August 11, 2009 at 3:50 am
From BOL:
Under the bulk-logged recovery model, if a log backup covers any bulk operations, the log backup contains both log records and the data pages that were changed by bulk...
August 11, 2009 at 1:24 am
Lynn, I see some "green" missing from your avatar today, could that be a problem with my display options? 😀
Barry is leading a new wave...
August 11, 2009 at 12:57 am
Please note I'm asking for an article review, either a technical review or comments on language, phrasing, easy of reading/comprehension.
English is not my first language, so I'm sure any comment...
August 10, 2009 at 6:40 am
I'm not sure I understand what you want to do.
I suggest you post your tables definition, some sample data, what you have coded so far and the desired output.
See this...
August 10, 2009 at 4:21 am
Your post does not contain any information that could allow anybody to help you.
I suggest you take a look at this article and add some more info on your post.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Regards
Gianluca
August 10, 2009 at 4:16 am
You could add EXECUTE AS OWNER to the procedure that contains the xp_cmdshell call.
This allows the user to execute that particular procedure with the rights of the user that owns...
August 10, 2009 at 4:13 am
Viewing 15 posts - 4,936 through 4,950 (of 5,394 total)