Viewing 15 posts - 3,571 through 3,585 (of 6,216 total)
Running sp_dbcmptlevel dbname will display the level, just add the new level like this: sp_dbcmptlevel pubs dbname, 80
Andy
August 3, 2002 at 1:50 pm
You need to grant execute permissions to the procedure, for the user/login you're using to connect to the database.
Andy
August 3, 2002 at 12:19 pm
What compatibility mode is your db in? SQL2K will script items with the column collation included, thats not valid against a SQL7 installation or a db in 70 mode.
Andy
August 3, 2002 at 11:40 am
There is a trace flag that will do "pretty print" in QA, maybe you could use that. Its #257. See the following article about trace flags in general:
http://www.sqlservercentral.com/columnists/RDyess/traceflags.asp
Andy
August 2, 2002 at 7:59 pm
You need to keep the log backups from the time of the last full backup.
Andy
August 2, 2002 at 6:07 pm
Been a while since I used Access, do remember part of this - even though the view is to a table that has a primary key Access doesn't pick it...
August 2, 2002 at 2:12 pm
15 mins isnt a bad number to use. How much can you data in minutes can you afford to lose? If you do the backups it takes up space. If...
August 2, 2002 at 2:10 pm
All you need to do is reattach. You can use Enterprise Manager to do it in SQL2K, or the stored procedure sp_attach_db in either SQL7 or SQL2K.
Andy
August 2, 2002 at 9:17 am
If you want the data updated every 30 minutes you need to either use snapshot and run it every 30 minutes, or transactional. By default transactional will run continuously and...
August 2, 2002 at 2:29 am
Hey Jorend, thats the first time anyone has said I was too easy on the opposition! Very interesting comments, thanks for reading and posting.
David P,
I like GUID's and have begun...
August 1, 2002 at 7:05 pm
Good reply. Im not a DTS Wizard (that would be Brian K!), what I've to be pretty effective is to create the package, save as VB code, then just add...
August 1, 2002 at 6:58 pm
I've got it running right now, MSDE as the main instance, two named instances of SQL. No problems.
Andy
August 1, 2002 at 5:35 pm
August 1, 2002 at 5:35 pm
I'll try to find an example on the openrowset. On sp_spaceused you can pass a table name to it, then you only get one result set I think.
Andy
August 1, 2002 at 8:58 am
Not sure Im clear on what you want to do. Sounds like you want to do transactional but with some special filtering? You'llhave to drop the pub to switch replication...
August 1, 2002 at 8:57 am
Viewing 15 posts - 3,571 through 3,585 (of 6,216 total)