Viewing 15 posts - 241 through 255 (of 408 total)
Looks like a path error to me "'G:\SQL\LogShippingPRODbihourly_ound.TUF'" should perhaps be "'G:\SQL\LogShipping\PROD\bihourly_ound.TUF'"?
Joe
August 20, 2007 at 8:35 pm
Dave -
In our case we had a lot of issues with custom extended stored procedures (e.g. c++ applications) that had been written to interact with 32-bit SQL Server 2000 via...
August 17, 2007 at 2:48 pm
Hate to throw this out but has anyone else taken into consideration the fact that SQL 2008 pretty much requires 64-bit?
As for reasons to choose 64-bit:
(1) Memory, memory, memory, no...
August 16, 2007 at 11:53 pm
I didn't mean to imply that the goal is to hunt down and kill the offending process - my assumption would be that the process that is causing the log...
August 16, 2007 at 8:27 pm
Abhisek -
Please keep us informed of the results of your quest, let us know how it works out for you.
Joe
August 16, 2007 at 8:21 pm
Kyle -
Modify your insert statement to include the column names in your table (e.g. insert table (column1, column2, column3) and let us know the results... I can't even get your...
August 15, 2007 at 10:58 pm
Check the requirements for enterprise edition, basically standard and enterprise versions require a server O/S. If you need enterprise features on a workstation O/S take a look at developer edition.
Joe
August 15, 2007 at 10:54 pm
OK, this will be interesting, dbcc shrinkfile is definitely the right answer but how far you will be able to shrink the log file will vary according to the number...
August 15, 2007 at 10:49 pm
Not necessarily - I just saw a post on here from a user with a problem with another OLE DB driver, sybase I think, running out of memory... odds are...
August 15, 2007 at 10:22 pm
Thomas -
What make/model of firewall are you dealing with? My thought would be that the firewall is automatically closing connections after a specific period of perceived inactivity, perhaps that particular...
August 15, 2007 at 10:16 pm
Hmmm... that sounds reasonable, a driver to connect to a BES server?
Question would be what/how will the blackberry datasource be polled for notes/activities? A middleware application or DTS package or...?
Joe
August 15, 2007 at 9:27 pm
Dave -
What is the proposed use of the driver? Usually you would install a driver to allow for the creation of a linked server or to allow a sql server...
August 15, 2007 at 8:43 pm
MDE, OK that helps a little bit let me fiddle with my copy of MS Access... is there any chance you are using a sql account to connect to the...
August 15, 2007 at 8:33 pm
The "blow out" to a much larger tlog size is usually due to a large transaction of some kind, whether a large data load or logged operation that consumes a...
August 15, 2007 at 7:25 pm
Butch -
OK, now you've made me wonder... the only way I can think of that the users could be hitting your PC would be if the application is supposed to...
August 15, 2007 at 7:18 pm
Viewing 15 posts - 241 through 255 (of 408 total)