Viewing 15 posts - 856 through 870 (of 1,222 total)
I don't know what this error means either but I suspect that it is being caused because you are trying to use UNC names for the folders but do not...
October 30, 2008 at 8:55 pm
You could do something like
Create View Clint AS
SELECT CONVERT (CHAR(25), Null) AS Name ,
CONVERT (INT, 0) AS Age
WHERE...
October 30, 2008 at 8:39 pm
First - is the migration of data occurring in a single database transaction or multiple ? If it is a single transaction then you should expect that your log...
October 29, 2008 at 9:37 pm
I haven't migrated from SQL 6.5 to SQL 2000 or SQL 2005 but I have done it to SQL 7.
A little background first...the physical structures used by SQL...
October 29, 2008 at 9:24 pm
You can choose which server you wish to use for the ReportServer and ReportServerTempdb databases.
You do not need to install SQL Server (database engine) on your 4th server...
October 27, 2008 at 9:04 pm
The "ForEach Loop" container is what you need to loop through the list of files. When you use this, the container gives you a variable which is the name...
October 27, 2008 at 8:59 pm
This is out of the box functionality of replication. Replication will validate record counts and/or checksums of articles in a publication.
Have a look at article "How to: Validate Data...
October 23, 2008 at 8:18 pm
You need to make your that the client components of Analysis Services are installed on the project server side of things.
October 15, 2008 at 8:49 pm
Jack is correct - there is no problems with a SSIS package being developed on your SQL 2005 server and run from that server but accessing (for reading or writing)...
October 14, 2008 at 9:00 pm
I assume that by now you have tried fixing using DBCC without any useful result.
If you have been able to determine which row is the problem, you should...
October 14, 2008 at 8:51 pm
Any scheduling product that can run DTEXEC can be used to schedule a SSIS package. By far, the easiest is SQL Server Agent which knows a lot about SSIS...
October 14, 2008 at 8:46 pm
A user is normally allowed to start jobs that the user owns. This is the simplest option although it may not be an option if more than one non-admin...
October 13, 2008 at 9:26 pm
You can use a dataset as the source for parameters. First create the dataset (e.g. SELECT ID, Label from yourtable) and then go to the report parameters and change...
October 12, 2008 at 9:42 pm
When you reset the encryption key, you should have received a warning that encrypted data would be deleted. This means that you will have lost part of connection string...
October 9, 2008 at 8:53 pm
Viewing 15 posts - 856 through 870 (of 1,222 total)