Viewing 15 posts - 35,626 through 35,640 (of 39,720 total)
To clear the log file, you need to run a "backup transaction dbname with no_log", not delete it. Can you restore the file? (ldf)
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com...
December 1, 2003 at 11:51 am
Have you checked the error logs? Perhaps there was an issue loading one of the logs.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 1, 2003 at 11:41 am
The saving data locally is something in the application, correct? It's not a SQL or Access thing AFAIK.
In SQL this will not occur automatically, the application would have to handle...
December 1, 2003 at 11:40 am
Shouldn't be unicode. Is your server setup for Unicode? What code are you running to get the Unicode results?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 26, 2003 at 10:33 am
Good question. I'm not sure. Everything I've seen on CALs is based on the types of connections. If you're completely internal, I don't think that you need to buy per...
November 25, 2003 at 5:28 pm
Not that I know of, but I bet you can generate an install file using setup by running through the unattended install process and selecting only the client install.
Search "How...
November 25, 2003 at 5:20 pm
The only way I know of is to actually sniff the network. You can see the result sets from Query Analyzer and I'd be extremely surprised if there were malformed...
November 25, 2003 at 5:19 pm
no
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 25, 2003 at 5:17 pm
For small business edition, I think it's Standard since clustering, log shipping, etc. don't seem to be supported.
For IIS usage, client licenses are required if your clients that connect are...
November 24, 2003 at 9:58 am
Not sure myself. Every SQL Server install I've seen in the US has resource 1033.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 24, 2003 at 9:51 am
The downsides of MSDE used to be that it wouldn't run more than 5 concurrent queries and it would degrade performance. Also no tools included with it, but this new...
November 24, 2003 at 9:47 am
AFAIK, the NDA is lifted for Beta 1. We are checking on specifics as well since we have some Yukon content.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 24, 2003 at 9:45 am
congrats!!!!
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 21, 2003 at 11:15 am
hadn't noticed that. Which snap ins?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 21, 2003 at 11:13 am
select a.id
, b.value
, c.value
from a
inner join b on a.id = b.fid
left outer join b as c on...
November 21, 2003 at 11:11 am
Viewing 15 posts - 35,626 through 35,640 (of 39,720 total)