Viewing 15 posts - 796 through 810 (of 1,222 total)
HAve a look at SSIS Configurations. This is exactly why this functionality exists. You can store the location of files in a configuration (which can be stored in...
May 4, 2009 at 9:37 pm
I would not expect to be able to install SQL Server Enterprise Edition on Windows XP - hence the error you are getting. The closest you would get to...
May 4, 2009 at 9:34 pm
Before choosing to remove BUILTIN\Administrator, please be aware that this is the default mechanism used by SQL Server to grant the local admin group SysAdmin privilege to SQL Server. ...
May 3, 2009 at 10:15 pm
I have seen this behaviour in the past and as far as I know, this cannot be changed. The changed value does not update anything back on the server...
May 3, 2009 at 10:08 pm
The problem is almost certainly occurring because during the generation of the snapshot there is a shared readlock on each table. This is done to ensure that the snapshot...
May 3, 2009 at 10:05 pm
The addition of a file to the existing file group (PRIMARY) is all you need to do. SQL Server will automatically start using it. The application does not...
April 30, 2009 at 9:21 pm
Your definition of when the backup chain ends is not correct. A full backup does not end the chain. The chain is terminated when there is a discontinuity...
April 28, 2009 at 9:53 pm
What is wrong with using the SSIS Lookup task ? It does exactly what you need.
April 28, 2009 at 9:46 pm
The relationships disappear from the diagram because they are not in the database you copied the diagram to. The diagram does not actually contain the relationships. It simply...
April 28, 2009 at 9:43 pm
The short answer is Yes, SSAS can do what you are after. You need to create a calculated member (measure) that checks whether the number of responses (using the...
April 27, 2009 at 10:02 pm
I am not able to give you a solution to this one but try the following:
Grant access to an account on the SQL Server computer...might need you to create a...
April 23, 2009 at 7:06 am
Hi Jay
yes your understanding is OK. If you want more information, there are various web sites that are really good resources including MSDN, sql-server-performance.com and, of course, SQLServerCentral.com
Cheers
Stephen
April 21, 2009 at 4:11 am
This error is probably happening because the account that service being used to run SQL Server
does not have access to the share.
The query you are using runs...
April 20, 2009 at 10:51 pm
There is a report property called "Auto Refresh" - if set, the report will automatically refresh itself with the frequency you set (in seconds).
I don't think that this can be...
April 16, 2009 at 10:29 pm
SQL 2000 Standard Edition does not support clustering.
SQL 2000 Enterprise Edition supports 2 notes and SQL 2000 Data Centre Edition supports 4 nodes.
April 15, 2009 at 10:44 pm
Viewing 15 posts - 796 through 810 (of 1,222 total)