Viewing 15 posts - 4,021 through 4,035 (of 6,216 total)
I'll have to agree with that point, 128m is way short of enough. It's cheap enough these days. Not to kick you around, but our standard end user machine at...
June 13, 2002 at 5:02 am
We've got a couple good articles here on the site about dynamic sql and how to achieve the "almost same" results with static code. Works but not pretty in my...
June 13, 2002 at 4:56 am
June 13, 2002 at 4:51 am
Nope. One of our advertisers - SQLZip - has a decent product that does exactly that though. You can read my once over here:
http://www.sqlservercentral.com/columnists/awarren/reviewofsqlzip.asp
Andy
June 12, 2002 at 5:05 pm
Im pretty sure that bug has been fixed. Not often you want to use that option since it requires single user mode.
Andy
June 12, 2002 at 4:25 pm
Generally you want to size it big enough so that it doesn't have to expand. For some db's that might be a couple megs, for others a couple hundred. You...
June 12, 2002 at 4:23 pm
Merge replication might not be so bad, that way you can make your changes to data on either server.
Andy
June 12, 2002 at 9:52 am
I wouldnt say the exams are super hard, really depends on where you're at with SQL and how much of it you use. I don't do much with merge replication...
June 12, 2002 at 8:45 am
Have you tried RESTORE DATABASE MyNwind WITH RECOVERY?
Andy
June 12, 2002 at 8:41 am
Not sure what "customized" means either. A view is a view, in SQL2K you can have distributed views and indexed views, but they all work the same.
Andy
June 12, 2002 at 5:18 am
It's behaving correctly. The job status won't change until the log reader completes, so it will continue to show as failed until the next time you stop/start the job. Doing...
June 12, 2002 at 5:15 am
Sounds like a good place to start. Only other thing I can suggest is check to see if you have multiple instances of SQL running. Log is not a standard...
June 12, 2002 at 5:14 am
Totally agree with Antares - we appreciate all comments, but let's have a professional discussion. I'd be curious to hear more about "VB" falling apart, in my experience it's usually...
June 11, 2002 at 6:14 pm
No reason you can't code your own using ADO if you need it. Just put all the code in a module, support a couple command line params or an ini...
June 11, 2002 at 6:09 pm
Wont work like that, you have to build up a string, then use exec() or sp_executesql, like this:
set @sql='select * from ' + @tablename
exec(@sql)
Andy
June 11, 2002 at 6:08 pm
Viewing 15 posts - 4,021 through 4,035 (of 6,216 total)