Search results for query: *

Posts 24 How do I convert as/400 time field being seen as dt_I8 to string I am struggling getting a time field from as/400 into SQL 200 using SSIS. The time field for some reason is being seen as dt_I8, And every type of conversion I try to do with it, it gives me an error...

I am trying to import data from our as/400 to SQL server. We have a new server with SQL 2005, data is restored so now I am trying to convert our DTS over to SSIS but I can's seem to get a connection set up that will talk with our as/400. One note on our current sql 2000 I have no issues. Our...

I have some DTS I have using the migration wizard to bring them over to SQL 2005. I have created a package and can sucessfully import them on the server but if i try to do it on my laptop I get a very generic error one or more errors occurred. there should be more specefic errors proceeding...

We are in process of migrating from SQl 2000 to 2005. We are doing a side by side since we have gotten a new server. I am working on imorting all my DTS over. I have used the import and saved them in MSDB like it was in 2000. Question on how to just view the package. From what I have read you...

I am in process of moving my SQL server over to SQL 2005. I am doing a side by side. I have restored it to SQL 2005. Most thing appear ok. Last night I set up a maintenance plan to re-index. It failed but gives no reason. If I view job history. I see where it starts re-indexing and re-indexed...

We had the server our SQL 2000 db were on on fail. It doesn't look like we can get that server up an running quickly. So we plan on getting a new server for it. But temporarily we have another server that currently has SQL 2005 on it and installed. So I would like to restore db from tape and...

I have a table called Tmpstockledger that I am trying to update stockledger with. Ths issue is TMPStockledger has multiple records based on the join and its only updating with values from first record in TMPSTOCKLEDGER. How do I get it to update with both values. I'm updated a bunch of values...

Is there anyway to let a non sys admin see the status of a job running that they are not owners of without adding them to the sysadmin role? Everything I keep reading says they have to be in the sysadmin role in order to see the job status.

I am trying to install sql 2000 standard on a user's laptop. It has Windows XP SP1 on it. It's telling me that the operating system is not supported. Any ideas? Stacy

Can some one tell me why I am getting the following error when I run the below query: Error msg: Server: Msg 8624, Level 16, State 16, Line 1 Internal SQL Server error. Query: SELECT REPLACE(STR(dbo.Store.StoreNum,3),' ','0') + ' '+dbo.Store.StoreName...

I have a table in which I am expanding about 10 fields. I'm issuing the alter table commnand individually. I have expanded 7 of them suscessfully but the other 3 I'm getting an error. This is the command I'm using: Alter Table WeeklysalesHistory Alter column costofsales decimal(11,0) It...

I was wondering what authority I have to give a user in order for them to be able to monitor sql jobs. I've given them access to targetserversrole which allows them to see all the jobs. But if they hit F5 refresh it does not refresh the job. It still says not running even though it is running. I...

I was wondering what authority I have to give a user in order for them to be able to view the sql server logs(not the transaction logs) through enterprise manager.

We have a server with 3 GB memory. We are using SQL 2000 Standard Edition. I thought I remembered reading somewhere you can only use 2gb with standard edition. But I've read somewhere that you can configure it to use more. In my scenerio is it possible to configure sql 2000 to use all 3 GB...

I have sql profile that basically is the sign-on used to sign on to sql server so that they can check jobs/run jobs. I want to be able to run and see the scheduled jobs with this profile. And I figured out they have have the system administation server roles otherwise they can only see jobs...

I want to take away the ability to create new package from my SQLOPERATOR profile. Basically this profile is used just to logon to the sql server and run DTS loadup jobs for our datawarehouse. What do I need to take away so that they can not create packages. Is there some document that explains...

We are in the process of installing a new Server which has SQL 2000 on it. I transferred everything over from a SQL 7.0 server including the DTS packages. I am in the process of updating my DTS packages. I have to go in and change the connections to point to the new server. THe first package...

I was trying to go into current activity in enterprise manager. I am getting a time-out error - error 1222. There was a re-index running when I was attempting to get to the current activity info. Is there somewhere I can increase the time-out info for connecting to the current activity. I...

I am trying to use the DTS transfer login task to transfer my logins from my SQL 7.0 server to my sql 2000 server. These are on different machines. I've created a new package on my new server - SQL 2000. I've selected the transfer log-in task, under properties/source I have PRFDSS which is my...

I am installing SQL 2000 on a brand new server. Once installed I will need to restore my db's from our current SQL 7.0 server. I know I can restore the user db's. I've read that you can not restore the MSDB and master db's. So What steps would I take to make sure I get all the info in these...