Answer Questions
Ilian cannot insert data sometimes
The database sometimes cannot insert data through the visual basic 6.0 application. I don't know why it happens. I watch the process id in the following path and find out many processes are in sleeping status. In Enterprise Manager, ->SQL Server Group -> server name -> Management -> Current Activity -> Process Info I guess the problem come from the maximum session of the process, but I am not familiar with the database infrastr ...Show All
Flynn Arrowstarr How to move the whole SQL 2005 instance?
Hi, What is the simplest way to move the whole instance from one box to another. I can stop all SQL services for couple hours, it's no problem. But I'd like to make absolute copy. So I need to move all databases, logins, roles, triggers, stored procs, packages, jobs, credentials, endpoints, proxys, etc. I need just replace the server (the box itself) with a new one. Thank you. Would it transfer everything Scheduled jobs Credentials Proxies ...Show All
Brass Ring Convert from unicodestring to uniqueidentifier
Hello, I have a XML data source containing strings representing GUIDs (ie <modelAsset id="e04ba23c-0401-43a9-b40c-b4c3d580caa9" />) and I need to fill a SQL table with uniqueidentifier column. I added Data Conversion component setting the data type as DT_GUID. Running the package I get the following error message: Error: 0xC02020C5 at Import MyALM settings, Data Conversion [1301]: Data conversion failed while converting column "id" (4645 ...Show All
winterxu416 SQL Backup for first n rows...
Hello, Im working on a data conversion project which deals with huge amount of data which needs to be sent to & fro on the internet to various teams atleast once in 15 days. A full backup could be to the tune of 900 Mb. Is there any way to do a SQL Backup for say the first 100 rows of each table in the db Also, this poses a problem of relationships. Could anyone help me out with this please.... thanks in advance, Satya ...Show All
SANDEEP MAMUNURI Custom Source Component Problem?
Hi,I have developed a custom source component to get data from a generic odbc connection with some special caracteristics. The component works fine by getting and mapping the output fields etc... The only two problems existing are that when i run the task it says that the data flow has no components inside... how is this possible since i have my source mapped to a flat file inside that data flow This is the error: SSIS package &q ...Show All
DPaul Web App Failover problem
Hi, I have successfully set-up a DB mirroring. When the pricipal goes down, the mirror picksup and the other way around too. So the mirroring part is working great. However, when I use my web applicaiton (dot net 2.0), it is not able to connect to Mirror server . I get the following error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that und ...Show All
Emerald Ally SQL 2005 Express not for Windows 2000 Professional????
I read that SQL 2005 Express will not work on Windows 2000 Professional but the other version will work on Windows 2000 Professional as long as it has SP 4. What sense does this make and it sure hinders design of applications since many of our customers still use Windows 2000 Pro. Hey Jim. I'm verifying internally which should be correct, I'll get back to you as soon as I get a definate answer, and will alert the appropriate authorities t ...Show All
IGK Cannot connect to Database in Server Management Studio
I currently can't connecto to my database in SQL Server 2005 (enterprise) but as soon as I try to use any functions, I get cryptic errors found below. I am about to pull my hair out. Everything was working fine for around 4 days and now everything just blows up. I've tried using both sql authentification and also windows: Errors I'm getting (print screens): http: / / www. photopizzaz. biz/ junk/ sqlserver_ 2005_ ...Show All
Germ&#225;n Schuager performance issue with trans log on tempdb?
I am running in to a tricky issue, and am hoping someone here has seen something like this before. Here's the basic sequence I am working with. A temp table #A contains some number of rows (in this case, about 45k rows). 1. Create temp table #B and insert a subset of the rows in #A (in this case, the subset happens to be 100% of #A) 2. Perform a few dozen updates to #B, using data from permanent tables. 3. Update the rows in #A with #B, ...Show All
orygreg Problems with Printing and rendering to PDF
Hi, I have an SQL server 2000 and I am creating a simple 1 page report using the Reporting Services and Visual Studio 2003. Everything is working fine. When I on "Preview" or when I access the report using a URL to disply it in HTML, I get a perfect report. However, when I click on the "Print Preview" Icon (in the Preview Tab), or when I Render it as PDF, something goes wrong and it divides the report in 2 pages. On the firs ...Show All
abv10200 Accessing AS400 Data
I've been trying to use the integrations services to access AS400 data with almost no success. Any suggestions or help you can give me would be appreciated. Some of the issues I can't make sense of are the following. 1. When I set up an OLEDB data source for the AS400 (using IBM's Client Access provider) I always get a warning message about "Cannot retrieve the column code page information from the OLEDB provider". & ...Show All
traal SQL SERVER 2005 REPLICATION (SNAPSHOT GENERATION FAILING)
I'm getting this error when I try to generate a snapshot for "merge" replication. I have added the articles one-by-one to try and narrow the problem down. I get this error on specific articles. Any help is appreciated. 2006-03-23 18:23:14.35 Server: MYSERVER 2006-03-23 18:23:14.35 Database: MYDB 2006-03-23 18:23:14.35 Command Text: sys.sp_releaseapplock 2006-03-23 18:23:14.35 Parameters: 2006-03-23 18:23:14.35 @Resource = MYS ...Show All
sandyalmeida Can't Create New Database on Device via ActiveSync
In VS2005 RTM using Server Explorer --> Right Click DATA CONNECTIONS --> Add Connection --> Datasource=Microsoft SQL Server Mobile Edition--> Data provider = .NET Framework Data Provider for SQL Server Mobile Edition--> ActiveSync Connected Device when I hit Test Connection I hear ActiveSync's connect sound and I get this error Microsoft Development Environment Microsoft 5QL Server 2005 Mobile Edition and/or NET C ...Show All
Bryn Kaufman xp_sqlmaint fails sqlmaint.exe succeeds
MSSQL 2000 SP4 Recently our maintenance jobs started failing. The only error which is traceabel is if we log an individual log step, other wise the job does not log. The error returned is: Job 'Transaction Log Backup Job for DB Maintenance Plan 'SomeName'' : Step 1, 'Step 1' : Began Executing 2006-03-27 07:55:20 Msg 22029, Sev 16: sqlmaint.exe failed. [SQLSTATE 42000] I have removed and recreated the maintenance plan. Attempted ...Show All
kvkris Identity column not returnd after AddNew / Update with ADO and SQL 2005
Hi, I add new records to a table with ADO. The tables contain an auto-increment identity column. I want to retrieve the identity value after the insert operation. This works fine for SQL Server 2000. On SQL Server 2005 this only works if I use a table in the select statement. If I use a view in the select statement, ADO returns no value for the identity column, a trace with profiler shows that there is no Select @@IDENTITY statement. What ...Show All