sqlserverq.blogspot.com

SQL server questions

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...

http://sqlserverq.blogspot.com/

OVERVIEW OF sqlserverq.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

19

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR SQLSERVERQ.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

October

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Saturday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 4.5 out of 5 with 11 reviews

5 star

9

4 star

0

3 star

1

2 star

0

1 star

1

Hey there! Start your review of sqlserverq.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

1.1 seconds

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT SQLSERVERQ.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

19

SSL

EXTERNAL LINKS

80

SITE IP

216.58.216.225

LOAD TIME

1.094 sec

SCORE

6.2

PAGE TITLE

SQL server questions | sqlserverq.blogspot.com Reviews

<META> DESCRIPTION

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...

<META> KEYWORDS

1 skip to main

2 skip to sidebar

3 activex script task

4 error

5 error code

6 posted by crystal

7 0 comments

8 email this

9 blogthis

10 share to twitter

CONTENT

Page content here

KEYWORDS ON PAGE

skip to main,skip to sidebar,activex script task,error,error code,posted by crystal,0 comments,email this,blogthis,share to twitter,share to facebook,labels activex,code,component,database,failed,file,microsoft,mysql,oracle,package,retrieving,script,ssis

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

SQL server questions | sqlserverq.blogspot.com Reviews

https://sqlserverq.blogspot.com

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...

INTERNAL PAGES

sqlserverq.blogspot.com

1

SQL server questions: ABORT_XACT

http://www.sqlserverq.blogspot.com/2012/03/abortxact_2710.html

Tuesday, March 27, 2012. One of db batch processes that was running localy on the server, failed on. Our production MSSQL server, without any error neither in sql server errorlog. Or job log. Using lumigent I was able to extract following information about. 01:27:37.120 0000:004bceca ABORT XACT NULL . . . 0 64 0 0 0 0000141b:00000a52:041c user transaction. Server is MSSQL2000 with SP3a on W2000. What might be the reason for this failure? I would try running profiler and capture all errors and warnings and.

2

SQL server questions: Abnormally Large Backup Files

http://www.sqlserverq.blogspot.com/2012/03/abnormally-large-backup-files.html

Tuesday, March 27, 2012. Abnormally Large Backup Files. We seem to have an issue with our backup routine for one of the databases. On a daily basis, we have one of our databases back up to disk. However, I. Noticed that our backup file is huge (39GB! I checked the database, and. It says it is only using 586MB of space. I also checked the transaction. Log, and it says it is using 100MB of space. We have a weekly backup of the database, and it only takes up 921MB, so I. Any ideas would be appreciated!

3

SQL server questions: Abnormal RDA.pull termination

http://www.sqlserverq.blogspot.com/2012/03/abnormal-rdapull-termination.html

Tuesday, March 27, 2012. Abnormal RDA.pull termination. I am facing some issues with my RDA app. The process of events are something like below:. 1) The program shows a set of options in a combobox.Then navigate to the next page . After some processes, it should come back to the form with combobox. 2)The datasource of combobox is a table which is pu. Lled down eachtime when the page is loaded. The local db is deleted before each pull operation. If(File.Exists( My Documents Rda.sdf). The rda pull line is :.

4

SQL server questions: ABORT_XACT

http://www.sqlserverq.blogspot.com/2012/03/abortxact.html

Tuesday, March 27, 2012. One of db batch processes that was running localy on the server, failed on. Our production MSSQL server, without any error neither in sql server errorlog. Or job log. Using lumigent I was able to extract following information about. 01:27:37.120 0000:004bceca ABORT XACT NULL . . . 0 64 0 0 0 0000141b:00000a52:041c user transaction. Server is MSSQL2000 with SP3a on W2000. What might be the reason for this failure? Dbid of the database you are having problems with. About 32 bit app...

5

SQL server questions: ABORT_XACT

http://www.sqlserverq.blogspot.com/2012/03/abortxact_27.html

Tuesday, March 27, 2012. One of db batch processes that was running localy on the server, failed on. Our production MSSQL server, without any error neither in sql server errorlo. Or job log. Using lumigent I was able to extract following information about. 01:27:37.120 0000:004bceca ABORT XACT NULL . . . 0 64 0 0 0 0000141b:00000a5. Server is MSSQL2000 with SP3a on W2000. What might be the reason for this failure? ThanksI would try running profiler and capture all errors and warnings and. About 32 bit ap...

UPGRADE TO PREMIUM TO VIEW 14 MORE

TOTAL PAGES IN THIS WEBSITE

19

LINKS TO THIS WEBSITE

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&#0...

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).

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).

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&#46...

3gramforsqlserver.blogspot.com

3G ram for SQL server: A difficult Combining Rows problem

http://3gramforsqlserver.blogspot.com/2012/03/difficult-combining-rows-problem.html

Tuesday, March 27, 2012. A difficult Combining Rows problem. I'm working to combine rows based on a time window and I am hoping to. Be able to write a stored procedure to do this for me, rather than have. Parse through all this data in my program. I'm not very well versed. With T-SQL syntax. just enough to get by selecting using inner joins,. Updating and inserting. thats about it. (Hence why I am here.). The raw data I have below looks like this:. GroupID, StartTime, EndTime, Min, Max, Points. Getting a...

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_27.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. Not the Face" wrote:.

3gramforsqlserver.blogspot.com

3G ram for SQL server: a different identiy columns in replication question

http://3gramforsqlserver.blogspot.com/2012/03/different-identiy-columns-in.html

Tuesday, March 27, 2012. A different identiy columns in replication question. Ive got a little bit of a Replication background but never. With "immediate updating with queued updating for. Failover" like Im testing now. In fact Ive never even done. Just "immediate updating". I seen lots of horror stories. Here about identity columns causing replication problems. For people and was expecting to get them during my testing. This week but I havent. Im curious as to why and thought. Curious to find out what i...

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).

UPGRADE TO PREMIUM TO VIEW 70 MORE

TOTAL LINKS TO THIS WEBSITE

80

OTHER SITES

sqlserverpower.com

SQL Server Power

Utilities for the SQL Server community. Welcome – SQL Server Power is a new web site aimed at developing free and/or low cost utilities for SQL Server and related Business Intelligence (BI) products. Our utilities are targeted towards three audiences. Currently, we have only 2 utilities…. Binary Compress. But, more utilities will be uploaded soon. Thanks for visiting the site. If you have any feedback, ideas, or questions about a product, please contact us.

sqlserverpowershell.com

SqlServerPowershell

Get Backup Directory for all Sql Servers via Powershell. May 1, 2015. Quick script to spit out the backup directories for your sql servers. Import-Module SqlPS -DisableNameChecking $objects = @(); try{ gc -Path c: Servers.txt %{ $srv = new-object Microsoft.SqlServer.Management.Smo.Server $ $objects = [PSCustomObject]@{ ServerName = $srv.Name BackupDir = $srv.BackupDirectory } } $objects Out-GridView } catch{ $ fl -Force }. Remove Database User and Login via powershell. April 24, 2015. Import-Module SqlPS...

sqlserverprofiler.com

Under construction

sqlserverprogrammer.com

..:: SQL Server Programmer ::..

November 10, 2012. Coding Guidelines and Conventions. System Development Life Cycle. SQL - User Management. SQL - Customer Management. Webform - Customer Magement. Winform - Customer Management. IPad - Customer Management. Winform - Management Reports. Webform - Management Reports.

sqlserverprojectsupport.wordpress.com

Sqlserverprojectsupport's Blog | Just another WordPress.com weblog

Just another WordPress.com weblog. June 1, 2010 in Uncategorized. The below query changes the schema from HumanResources(Old) to Person(New). ALTER SCHEMA Person TRANSFER HumanResources.uspUpdateEmployeeHireInfo. Moving Data from SQL Server 2k to 2k8. May 21, 2010 in Uncategorized. Https:/ blogs.msdn.com/zxue/archive/2010/05/10/moving-data-from-sql-server-2000-to-sql-server-2008.aspx. Moving Data from SQL Server 2000 to SQL Server 2008. Approach #1: SQL Server Import/Export Wizard. 2: Copy Database Wizard.

sqlserverq.blogspot.com

SQL server questions

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...

sqlserverquery.com

www.sqlserverquery.com

This Web page parked FREE courtesy of Domains Made Easy. Search for domains similar to. Is this your domain? Let's turn it into a website! Would you like to buy this. Find Your Own Domain Name. See our full line of products. Easily Build Your Professional Website. As low as $4.99/mo. Call us any time day or night .

sqlserverquerytools.wordpress.com

sqlserverquerytools

The Benefits Of Version 2012 SQL Server. Learning How to Use SQL Servers. Some Facts Concerning SQL Server Tools. Server Tools – Things You Need to be Aware Of. Ideal Ways to Manage Servers. The Benefits Of Version 2012 SQL Server. July 24, 2015. Database management, business intelligence, data integration and data integration with cloud based computing are the new improvements of SQL server version 2012 but this was released earlier at this year. Another benefit is the power view which an ad-hoc reporti...

sqlserverquerywriters.blogspot.com

SQL Server Query Writers

SQL Server Query Writers. SQL Training in Bangalore, MSSQL Query Writers, SQL Query Writers, SQL Server 2012 Query Writers, SQL Server Query Writers, SQL Server Performance Tuning Training, SQL Performance Tuning Training, SQL Server Online Training In Bangalore, SQL Server 2008 Training, SQL Server 2008 Administration Training, SQL Server 2008 Administrator Training, SQL Server 2012 Online Training. SQL Server 2012 for Query Writers. Sample Live Projects are provided. Old Madivala, BTM 1. Other Skills f...

sqlserverquest.com

T SQL Tutorial

All in One SQL Server. SQL Server Interview Questions. Tuesday, August 11, 2015. Properties to modified packet size on network. If your SSIS package gets its data from a SQL Server database located on an other. Machine, then the data of your query will go from the SQL Server machine over the network to your SSIS machine. This is done in small network packets with a default size of 4096 bytes (4 kilobytes). 10485760 / 32768) to fill one buffer. Default Max Buffer Size: 10 MB. Data Source=mySqlServer sql20...