sqlserverq.blogspot.com
SQL server questions: March 2012
http://sqlserverq.blogspot.com/2012_03_01_archive.html
Thursday, March 29, 2012. About activeX script error in ssis package in SQL server 2005. When i run activex Script it's shows this error. Retrieving the file name for a component failed with. Moving from .NET Framework Data Access and Storage. So is there a solution to this? I've had a similar error when using the scripting.filesystemobject from within a script task in ssis. About activeX script error in ssis package in SQL server 2005. When i run activex Script it's shows this error. That it is useful f...
sqlserverq.blogspot.com
SQL server questions: Aborting a thread CRASHES Sql Server 2000!
http://sqlserverq.blogspot.com/2012/03/aborting-thread-crashes-sql-server-2000_27.html
Tuesday, March 27, 2012. Aborting a thread CRASHES Sql Server 2000! I'm creating a new thread and executing a database import operation using a transaction. I have had several problems that I cannot explain, the most serious of them being that aborting this thread sometimes crashes the instance of Sql Server to which I was connected! Instead, this completely CRASHES the Sql Server instance! In the end, I had to REBOOT the server in order to bring Sql Server back to life. I should probably mention that I ...
sqlalert.blogspot.com
SQL Alert: Accessing Global Cursor
http://sqlalert.blogspot.com/2012/03/accessing-global-cursor.html
Tuesday, March 27, 2012. Here is the stored procedures that I used. DECLARE abc CURSOR GLOBAL FOR. Select * from sales. DECLARE @.sdate datetime. DECLARE @.sperson varchar(15). DECLARE @.sregion varchar(15). DECLARE @.sales int. FETCH NEXT FROM abc INTO @.sdate, @.sperson, @.sregion, @.sales. Print @.sdate. Print @.sperson. Print @.sregion. Print @.sales. When I execute globalCursorTest using SQL Query Analyser, it says. Server: Msg 16915, Level 16, State 1, Procedure globalCursor, Line 4. In DB2, one pr...
sqlalert.blogspot.com
SQL Alert: Accessing FTP site from sql server
http://sqlalert.blogspot.com/2012/03/accessing-ftp-site-from-sql-server_27.html
Tuesday, March 27, 2012. Accessing FTP site from sql server. How to create DTD compatible XML file from result set returned from a query. Can we access FTP site and upload this xml? Is it possible to do from Tsql? Hope this helps,. Http:/ msdn2.microsoft.com/en-US/library/aa197263(SQL.80).aspx. Maybe this site can help you with witing the extended store procedure to accomplish what you want to do. Please that DTD is deprecated , you may want to look into using XSD. Subscribe to: Post Comments (Atom).
sqlserverq.blogspot.com
SQL server questions: Abort a long running query
http://sqlserverq.blogspot.com/2012/03/abort-long-running-query.html
Tuesday, March 27, 2012. Abort a long running query. I would like to have a long running query aborted by SQL server, such that,. That query does not become a resource Hog and I can catch that in my client. Side code and display a nice error message to the user. Any way I could do that? I am sorry if this is being posted in the wrong forum. I would like to have a long running query aborted by SQL server,. Such that, that query does not become a resource Hog and I can catch. Any way I could do that? About...
sqlserverq.blogspot.com
SQL server questions: Abnormal user connection increased on SQL server
http://sqlserverq.blogspot.com/2012/03/abnormal-user-connection-increased-on_4461.html
Tuesday, March 27, 2012. Abnormal user connection increased on SQL server. The error which we are facing these days is related to the abnormal. Performance of SQL server, and sometimes also got the error ‘SQL Run-time. Error 2147217911(80040e09)’ sometimes on the client ends. As per our detailed observation it is observed that our SQL server database. Response sometimes get dead slow and that is why all the related application. And website responses gets slow as well. Noticed are that user connection on ...
sqlamo.blogspot.com
SQL About AMO: Access Denied - SQLSERVER 2005 Integration Services
http://sqlamo.blogspot.com/2012/03/access-denied-sqlserver-2005.html
Thursday, March 29, 2012. Access Denied - SQLSERVER 2005 Integration Services. I am getting access denied error cannot connect to server while trying to connect Integration Services. I am trying to connect from my laptop to the SQLSERVER database server. I followed the document Connecting to a Remove Intergration Services Server , doc id: aa337083. But I can connect to IS if I log remotely to the server. Any thoughts on this? I am getting following errors. Cannot connect to cvsslmdd1-vm. At Microsoft....
sqlremoveoldbackups.blogspot.com
SQL Remove Old Backups: 32bit vs 64bit SQL 2005
http://sqlremoveoldbackups.blogspot.com/2012/03/32bit-vs-64bit-sql-2005.html
Tuesday, March 27, 2012. 32bit vs 64bit SQL 2005. Just curious if anyone has any numbers for this. We have a customer that has their server running windows server 64bit. But, SQL 2005 loaded on it is only 32bit. What would be the benefits. Speed mainly) of upgrading to 64bit SQL - in numbers - like a 25%. Increase, or something like that. Or, is there some certain issue when. Running the 32bit SQL on 64bit OS that I need to be aware of. And is slow to deal with compared to normal memory). On a 64-bit box).
sqlremoveoldbackups.blogspot.com
SQL Remove Old Backups: 32-bit SQL2000 on 64bit OS
http://sqlremoveoldbackups.blogspot.com/2012/03/32-bit-sql2000-on-64bit-os_25.html
Sunday, March 25, 2012. 32-bit SQL2000 on 64bit OS. Can I install 32-bit SQL on a 64-bit Windows 2003 Enterprise Server? And if yes, how will it perform? That is not supported. Andrew J. Kelly. Patrick" anonymous@.discussions.microsoft.com wrote in message. News:B71D50F1-A9BE-4A5F-8231-287572D1F8E1@.microsoft.com. Can I install 32-bit SQL on a 64-bit Windows 2003 Enterprise Server? If yes, how will it perform? Why would you want to? Andrew C. Madsen. If yes, how will it perform? SQL Remove Old Backups.