Viewing 15 posts - 36,976 through 36,990 (of 39,524 total)
depends on the client. Could have a query timeout.
Steve Jones
August 19, 2002 at 4:40 pm
When the import fails, the transaction rolls back, and thus there is space left.
I'd increase the log to 100MB or so and see what happens. You can always shrink it....
August 19, 2002 at 4:39 pm
Great point. I wrote an article on Templates in Query Analyzer and how they use them, but had to release copyright to SQL Server Magazine. The link is here and...
August 19, 2002 at 9:48 am
I was surprised by this one. I thought the SQL passwords were one way hashes, and unbreakable. Apparently not.
These should scare you and make you enforce strong passwords.
Steve Jones
August 19, 2002 at 9:41 am
Depends on the script. If you do a script the whole database, then no, it will not. the database itself doesn't know about what is changed and what is not.
I...
August 19, 2002 at 9:30 am
Probably can script the sp_Addlogin using the domain name (existing), then re-run with a search and replace for the newone.
Steve Jones
August 16, 2002 at 11:33 am
I keep the permission with the object create script. That way they are added when the object is created.
The first time you do this, it's tough, but once you get...
August 16, 2002 at 9:58 am
Not likely to be anyway to do this except permissions. Is this a big problem?
Steve Jones
August 16, 2002 at 9:52 am
yes, but it will take time to recreate them. Dropping them decreases the load time, not the total time to get the table back to it's state.
Steve Jones
August 16, 2002 at 9:48 am
The listeners do not start unless the server reboots. This might be your problem.
Steve Jones
August 14, 2002 at 12:20 pm
Are you doing this in one transaction? You can set the size of the batch to commit.
Steve Jones
August 14, 2002 at 10:51 am
Is the path for the log file in existence? It will not create it. Use the WITH MOVE option to move the log file to a valid path.
Steve Jones
August 14, 2002 at 10:48 am
A good point and worth considering. as with most things, it depends on the business rules.
There may be a transient environment, like an ISP for example. If I sign up...
August 14, 2002 at 10:46 am
Viewing 15 posts - 36,976 through 36,990 (of 39,524 total)