Viewing 15 posts - 946 through 960 (of 1,222 total)
Well, if the transaction table has all of the transactions you are able to calculate the closing balance for any date. If, for some reason the transaction table is...
March 17, 2008 at 8:59 pm
The following should produce what you are after
CREATE TABLE MoneyTrans
([Id] [bigint] NOT NULL,
[TransDate] [smalldatetime] NOT NULL,
[TransName] [varchar](30) NOT NULL, -- CAN have values 'Deposit' / 'WithDraw'
[Amount] [money] NOT NULL...
March 17, 2008 at 8:36 pm
The replication agents run in the security context of SQL Server Agent. The account used for SQL Server Agent must have permission to read from the share that is...
March 13, 2008 at 10:19 pm
It is not you that is connecting to the remote server - it is SQL Server Agent. SQL Server Agent is running as account "localsystem" (you can see this...
March 13, 2008 at 6:23 pm
Has this setting changed recently ? For it to take affect, a restart of the SQL Server service is required
March 13, 2008 at 6:03 pm
The usual reason for the message
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
is because the server you are trying to connect...
March 13, 2008 at 5:53 pm
When you are configuring replication, Enterprise Manager checks whether SQL Server Agent is running because it is used to run each of the replication agents.
The user who is...
March 12, 2008 at 8:15 pm
The recovery model is in Master..sysdatabases (column Status).
Personally, I prefer to use the function DATABASEPROPERTYEX - less fiddling with bit masks and it is more intuitive.
e.g. SELECT DATABASEPROPERTYEX...
March 10, 2008 at 9:36 pm
SQL Server and Analysis Services are completely independent services and do not share any settings.
If you need to change the memory used by Analysis Services, you can do this using...
March 6, 2008 at 7:40 pm
Your average disk queue length is a serious cause for concern. There is a huge i/o bottleneck. I am not at all surprised that your customer is complaining....
March 6, 2008 at 7:30 pm
Text qualifier are used to explicitly delimit the data in a column where it is possible for the column to contain the character used as the field delimiter.
e.g....
February 21, 2008 at 7:51 pm
The connections are being made by your web server. Hence, regardless of how you get the IP Address, you will end up with the IP Address of the web...
February 19, 2008 at 9:14 pm
For what it is worth, even when I am working in the office, it can feel like no one notices you. I don't whether it is open plan offices...
February 19, 2008 at 9:00 pm
The numbers you quote seem OK to me. It really comes down to what the application is doing and what implications exist wrt reporting off the same database.
If the...
February 17, 2008 at 7:42 pm
You are sorting on a different column (b.somecolumn ) to the column that you are expecting to be ordered 1, 2, 3, 4 (which is sort_order).
Loosely, the way that...
January 17, 2008 at 7:12 pm
Viewing 15 posts - 946 through 960 (of 1,222 total)