Viewing 15 posts - 16 through 30 (of 64 total)
Hi
If you right click the properties on the SQL Agent in enterprise manager (while it is stopped). On the General tab you will find Service Startup account. You can change...
November 28, 2006 at 10:01 pm
Hi
Okay now XI comes with different content types if you are using crystal reports you have a number of ways to connect to SQL the best probably being OLEDB. Now...
October 22, 2006 at 1:23 am
Hi
Not sure if your data needs to be real time. But if not I think you could create...
October 19, 2006 at 10:18 pm
Hi
I noticed you have said the same version of SQL have you checked the service packs on both servers and both SQL installations?
Mike
October 18, 2006 at 12:56 am
Hi
What version of Business Objects are you using?
And what type of report content are you using(Webi, Crystal, etc)
Regards
Mike
October 18, 2006 at 12:54 am
Hi
Depends on the tables you are working with do they contain a field with a modified date? If not and you are working with MS SQL you could look at...
October 17, 2006 at 12:12 am
Hi
Is this a SQL2005 Database? Coz if it is you could use the new xml data type. It has been added to solve this sort of problem.
Regards
Mike
October 16, 2006 at 3:15 am
Hi
When you say brought down the server what exactly do you mean? Crashed it or Used all loads of resources.
Have you had a look at the execution plan on your...
October 13, 2006 at 2:53 am
Hi
Correct me if I am wrong but as far as I know you will still need the AS400 driver on the server to add it as a linked server?
Mike
October 12, 2006 at 6:50 am
Hi
When you execute the job manually it runs using your account details...When you schedule a job it runs through the SQL Server Agent start up account..Try stopping the agent and...
October 12, 2006 at 1:44 am
Hi
I think you are going to need to look at using the ActiveX taks.
1. Query the Access table to check the structure
2. Modify the SQL table if needed
3. Import the...
October 12, 2006 at 12:20 am
Hi
As far as I know No. Unless you want to dump to text files first then import the files.
Mike
October 12, 2006 at 12:16 am
Hi
This might sound like a kinda stupid question but have you checked to see if there is in actual fact data being returned? Other things to check could be the service...
October 12, 2006 at 12:10 am
Hi
I think you are onto something with the timeout...Can you monitor the network bandwith and check it against when you have errors in your DTS package?
Mike
October 11, 2006 at 1:42 am
Hi
Do you have the latest service pack installed? Secondly do you get any errors? or does it just not display?
Mike
October 11, 2006 at 12:22 am
Viewing 15 posts - 16 through 30 (of 64 total)