Concurrency Help
Mon, 19 May 2008 22:11:37 -0600
As indicated by some other posts I made, I'm creating a table that maintains
the order of its items.
This requires adding a sort column. It also requires the following tasks:
1. When adding an item, I need to find the maximum sort value so far and
then store the new item with a sort value that is one highe ...
|
Truncate Transaction Logs
Mon, 19 May 2008 13:32:00 -0700
Hello Everyone,
I'm not exactly sure where to ask this question but I'm having a problem
with a few of my databases with there transaction logs growing too large.
I'm running SQL 2005, and all my databases are Full Recovery model. My
backups usually truncate the logs however they seemed to stop doing that ...
|
Best Way to Implement Row Order
Sun, 18 May 2008 20:23:07 -0600
I have a requirement to provide users with the ability to control the order
of items in a table.
Requiring them to enter a number into a new column, which I would then sort
by, is not a valid option as it becomes too messy when they are adding,
deleting, or changing the order of items. Ideally, I would have ...
|
kostenlose com domains
web hosting de
com domain noch frei
de vu domain
com domain owner
Fri, 16 May 2008 16:41:51 -0700
kostenlose com domains
web hosting de
com domain noch frei
de vu domain
com domain owner
+
+
+
http://jhku.net/DOMAINS-KOSTENLOS/
http://jhku.net/DOMAINS-KOSTENLOS/
http://jhku.net/DOMAINS-KOSTENLOS/
http://jhku.net/DOMAINS-KOSTENLOS/
http://jhku.net/DOMAINS-KOSTENLOS/
http://jhku.net/DOMAINS-KOSTEN ...
|
free webspace vergleich
billiges webhosting
windows root server
rootserver de
www free webspace biz
Fri, 16 May 2008 12:11:21 -0700
free webspace vergleich
billiges webhosting
windows root server
rootserver de
www free webspace biz
+
+
+
http://jhku.net/WEBSPACE-KOSTENLOS/
http://jhku.net/WEBSPACE-KOSTENLOS/
http://jhku.net/WEBSPACE-KOSTENLOS/
http://jhku.net/WEBSPACE-KOSTENLOS/
http://jhku.net/WEBSPACE-KOSTENLOS/
http://jhku.ne ...
|
Can not connect to the ms sql 2005
Fri, 16 May 2008 14:32:00 -0400
Hi All,
Try to connect to the SQL Server 2005 and got the below err:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provid ...
|
Can't see server in Enterprise Manager when Exporting data
Thu, 15 May 2008 11:06:04 -0700
I have 2 SQL servers running on the network and when I use the Import/Export
wizard and click the drop down to show servers I only see one server. I can
manually type in the name of the other server and then I can see all the
databases in the server. My IT manager says the DNS is fine. Any Ideas?
Thanks. ...
|
|
|
WMI Configuration Trouble
Wed, 14 May 2008 15:31:39 -0400
When installing SQL Server 2005 Express I get the error "SQL Server System
Configuration Checker cannot be executed due to WMI Configuration on the
machine...."
I've looked online and found the WMIFIX.cmd which did not work for me.
I am running Windows Vista Home Basic.
Can you help me? ...
|
Difference between nvarchar and varchar
Tue, 13 May 2008 21:55:08 -0300
What's the difference between nvarchar and varchar? ...
|
syntax question
Tue, 13 May 2008 15:56:01 -0700
I have the following statements that seem to work to give me the date format
that I need for display but I am having trouble comparing it to another.
_add_days(cast('12/31/1899' as Date), cast([DATAMART].[CUSTDATE].[FILE04] as
int))
This give me the date in this format 'May 13, 2008'.
What I need is a s ...
|
