Viewing 15 posts - 31 through 45 (of 108 total)
That is exactly what I want. Thanks!
But... How do I keep this setting. It seems to go back each time I open a new query window. Can't find...
April 4, 2014 at 2:06 pm
My domain login gets me on the machine. I can add files via File Explorer/Windows Explorer. But I can't create a bak file in that same directory. ...
March 25, 2014 at 9:34 pm
Followup:
Here is a picture of what I see if I access the SQL data via Access/ODBC. How do I get rid of the Information_Schema & Sys lines?
(Picture...
March 25, 2014 at 9:01 am
The constraints would be simple ones - defaulting int types to 0, char to space(0), bit to 0, etc.
March 25, 2014 at 7:33 am
Hi.
This is a great function. Can you tell me if the system uses one database file for this function? I have created separate databases for...
February 27, 2014 at 8:37 pm
Luis Cazares (2/24/2014)
You can't chage that code to make it set based. You need to change the code from usp_make_record to accept several rows at a time.
Other than passing in...
February 24, 2014 at 9:25 am
Row count could be from a few dozen to 1000s. The process will be called by SQL internally and by Visual Foxpro externally via the ODBC driver.
February 24, 2014 at 7:45 am
According to the article, the Quirky Update is still significantly faster than the 'Over' option. Has there been an update or change on this?
Can others chime in...
February 16, 2014 at 10:49 am
Luis Cazares (2/14/2014)
February 14, 2014 at 2:28 pm
Luis Cazares (2/14/2014)
Have you even tried looking for "CREATE SCHEMA" on google?
Yes. I tried it - made the user - made the schema - logged in as the user...
February 14, 2014 at 2:10 pm
Actually,
Yes - we will be moving to SQL 2012 for the client that needs this. Can you elaborate?
Thanks,
Mike
February 14, 2014 at 1:49 pm
All,
It wants to "delete database backuphistory". This seems to be the issue. If I skip that, will I have issues later down the road?
EXEC msdb.dbo.sp_delete_database_backuphistory @database_name = N'xx_Training'
GO
USE...
July 9, 2013 at 8:54 am
A full backup doesn't set the log to re-usable?
February 6, 2013 at 9:10 am
Viewing 15 posts - 31 through 45 (of 108 total)