3gramforsqlserver.blogspot.com
3G ram for SQL server: A differential backup that seems to darn big...
http://3gramforsqlserver.blogspot.com/2012/03/differential-backup-that-seems-to-darn.html
Tuesday, March 27, 2012. A differential backup that seems to darn big. I have a db that is currently about 7 gb. It is currently on a test. Instance of SQL 2005. It is not being used by anyone but me for the. Purpose of learning one or two things about 2005. Here is what I deem. If i do a full backup of the database, I get a backup of 7 gb. If I then IMMEDIATELY do a differential backup, I get a backup of 4.7. If I then IMMEDIATELY do a differential backup, I get a backup of 4.7. Users and that I didn�...
3gramforsqlserver.blogspot.com
3G ram for SQL server: a Distinct Query
http://3gramforsqlserver.blogspot.com/2012/03/distinct-query.html
Tuesday, March 27, 2012. I have 2 tables as following :. I want to write a query to see the Authors and their last articles with no distinct values. Like AuthorImage - AuthorFullName - ArticleTitle - ArticleDate. If anyone knows the solution i will be glad . Thanks from now onselect AuthorImage, AuthorFullName, ArticleTitle, ArticleDate = aDate. From tbl Authors a. Select AuthorID, aDate = max(ArticleDate). From tbl Articles) x. On aAuthorID = x.AuthorID. Inner join tbl Articles b. From tbl Authors AUTH.
3gramforsqlserver.blogspot.com
3G ram for SQL server: a fcuntion to compare two tables
http://3gramforsqlserver.blogspot.com/2012/03/fcuntion-to-compare-two-tables.html
Tuesday, March 27, 2012. A fcuntion to compare two tables. I need a function witch compares two tables. Can some one help me? SELECT OneTable.*, TwoTable.*. ON OneTable.c1 = TwoTable.c1. AND OneTable.c2 = TwoTable.c2. AND OneTable.cn = TwoTable.cn. WHERE OneTable.key IS NULL. OR TwoTable.key IS NULL;. Olli d" info@.dithmer.de wrote in message. News:1193241328.829023.299090@.y27g2000pre.googlegroups.com. I need a function witch compares two tables. Can some one help me? Subscribe to: Post Comments (Atom).
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....