Installing SQL 2005 install in progress sertup error :
"Microsoft SQL Server 2005 Setup The cabinet file 'Sql.cab' required for this installation is
corrupt and cannot be used"I get the same error. Anyone have any idea what causes this?
Thanks.
Marcus
"Diamondas" wrote:
> Installing SQL 2005 install in progress sertup error :
> "Microsoft SQL Server 2005 Setup The cabinet file 'Sql.cab' required for this installation is
> corrupt and cannot be used"
>
>sql
Showing posts with label file. Show all posts
Showing posts with label file. Show all posts
Friday, March 30, 2012
Microsoft SQL Server 2005 Enterprise Evaluation Edition
I have installed Microsoft SQL Server 2005 Enterprise Evaluation Edition. The file size is now 4035. When I tried to add new data file name,I am getting the below error.
In the below site it says that there is no limit on the size but Iam still getting the problem
http://www.microsoft.com/downloads/details.aspx?familyid=6931fa7f-c094-49a2-a050-2d07993566ec&displaylang=en
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
Pls can any one help me.
Alter failed for database 'test'. (Microsoft.SqlServer.Smo)
An exception occured while executing a Transact-SQL statement or batch(Microsoft.SqlServer.ConnectionInfo)
Create DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096MB per database (Microsoft SQL Server, Error:1827)Seems that you instaleld SQL Server Express edition. The limitation mentioned applies to this edition. Run the SELECT @.@.VERSION on the machine you are using command.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||I did run select @.@.version on my machine, please find below the result of it
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
Please help
|||Hi,
so you either did not have Enterprise edition installed, or connected to the wrong instance.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
Wednesday, March 28, 2012
Microsoft SQL File I/O
Does anyone know how to do file I/O in T-SQL. When I say that I mean, I would like to get information from a '.dat' file, parse through it, grab information, then store the information in a database.(also what are the limitations if any to file i/o manipulation in T-SQL) After that is done I need to rename the '.dat' file, and cut and then paste it into an archive directory. Before I say fuck it and do it in C++, is it possible to do this in T-SQL (Microsoft SQL Server 2000).
Thank You
..NeoSounds kinda harsh when you put it this way, Neo.
But since you're so comfortable with C++, you'll feel like fish in the water with SQLDMO ;)|||You can't really do it well with T-SQL.
If you want to keep the functionality wrapped in your SQL Database, I would recommend a DTS Package, which nicely (graphically) blends COM and SQL functionality, though it can be a little frustrating to use when you are used to just doing things in code.
Short of that, you could create a COM dll and manipulate it with VB Script from a SQL Agent job.|||You can also use sp_OAxxx set of procedures to do pretty much anything you'd do with your C++.|||I can't, use any scripting languages. The code was originally written in ColdFusion. I am a C++ coder, not a SQL man, I was kind of thrown into this project (small company and I'm on Co-Op). The idea is to notuse any scripting language to do any "real" processing, so they want me to do it in SQL, as a Stored Procedure. I am not sure if it possible. I could do it in C++ in like 10 minutes. Also what is Pro*C/C++?
..Neo|||Well, if you can do it in C++ in 10 minutes, - why are you waisting your time?
You can use sp_OAxxx in your stored procedures, it's still T-SQL.
And what is Pro*C/C++?|||Well, I won't make a big deal about the fact that the sp_OAxxx sp's call window's scripting DLLs, so it's still really writing it in a scripting language...|||Agree, but it's still T-SQL that you implement this solution in. I think the guy is just flashing with something we can't see when he says that he can do it in C++ in 10 minutes. I CAN do it in 10 minutes using sp_OAxxx, and yes I am probably gonna use Scripting.FileSystemObject, but this is a well documented approach to OS file processing techniques, and I don't see anything wrong with it, other than being able to apply the right approach to resolve a problem.|||When I say I CAN do it in 10 minutes, all I'm trying to say is that I don't know SQL very well. I've done very little with it, and my company wants to stay away from scripting languages, becuase it is very slow when it does file manipulation, becuase it has to go through like 2 differen't engines.|||My only concern (generally speaking), and I could be wrong, is that you are tying up a SQL thread with the external tasks when you use sp_OA's, and that puts your SQL session in jeopardy (not sure if it is isolated). Using an ActiveX task with SQL Server Agent at least offloads that burden from the main SQL task.
To be honest, though, I do use them as well.
Thank You
..NeoSounds kinda harsh when you put it this way, Neo.
But since you're so comfortable with C++, you'll feel like fish in the water with SQLDMO ;)|||You can't really do it well with T-SQL.
If you want to keep the functionality wrapped in your SQL Database, I would recommend a DTS Package, which nicely (graphically) blends COM and SQL functionality, though it can be a little frustrating to use when you are used to just doing things in code.
Short of that, you could create a COM dll and manipulate it with VB Script from a SQL Agent job.|||You can also use sp_OAxxx set of procedures to do pretty much anything you'd do with your C++.|||I can't, use any scripting languages. The code was originally written in ColdFusion. I am a C++ coder, not a SQL man, I was kind of thrown into this project (small company and I'm on Co-Op). The idea is to notuse any scripting language to do any "real" processing, so they want me to do it in SQL, as a Stored Procedure. I am not sure if it possible. I could do it in C++ in like 10 minutes. Also what is Pro*C/C++?
..Neo|||Well, if you can do it in C++ in 10 minutes, - why are you waisting your time?
You can use sp_OAxxx in your stored procedures, it's still T-SQL.
And what is Pro*C/C++?|||Well, I won't make a big deal about the fact that the sp_OAxxx sp's call window's scripting DLLs, so it's still really writing it in a scripting language...|||Agree, but it's still T-SQL that you implement this solution in. I think the guy is just flashing with something we can't see when he says that he can do it in C++ in 10 minutes. I CAN do it in 10 minutes using sp_OAxxx, and yes I am probably gonna use Scripting.FileSystemObject, but this is a well documented approach to OS file processing techniques, and I don't see anything wrong with it, other than being able to apply the right approach to resolve a problem.|||When I say I CAN do it in 10 minutes, all I'm trying to say is that I don't know SQL very well. I've done very little with it, and my company wants to stay away from scripting languages, becuase it is very slow when it does file manipulation, becuase it has to go through like 2 differen't engines.|||My only concern (generally speaking), and I could be wrong, is that you are tying up a SQL thread with the external tasks when you use sp_OA's, and that puts your SQL session in jeopardy (not sure if it is isolated). Using an ActiveX task with SQL Server Agent at least offloads that burden from the main SQL task.
To be honest, though, I do use them as well.
microsoft sql database (*.mdf) using help ?
Hi
I use visual std. 2005 and I create a asp.net web page after >add item> sql database > I added my project *.mdf file when I make project my project is runnig with visual studio 2005 but I sent my hostting (internet server )I cant use this mdf file . Are we register this mdf file sqlserver ? can we use this mdf file like access file (mdb ) . What kind of thing I do to use this mdf file .
Thanks
I know some hosts don't support SQL 2005, FastHosts in the UK for exampe have no plans to allow the user of the SQL Express MDF files so it cannot work like an Access MDB file. They say that this is down to performance and security implications.|||
prokurs:
Are we register this mdf file sqlserver ? can we use this mdf file like access file (mdb ) . What kind of thing I do to use this mdf file .
No, you must have a SQL instance on the host to use mdf files. Although in VS2005 you can create mdf files and use them by attaching them to a SQL Express Instance (specified in the Data Source property in your connection string), you still need a SQL Instance to which you have access. So you must have a SQL2005/Express instance on the hosting machine, and then add proper permissions to your account.
|||hi can you look my mistake this mistake's source ishttp://www.prokurs.com/e/loginana.aspx you can enter this page after write random user name and passwors after then I have got a this mistake please help ?
Server Error in '/' Application.
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 under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details:System.Data.SqlClient.SqlException: 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 under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.Stack Trace:
[SqlException (0x80131904): 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 under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735091 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +820 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84 System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197 System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +1121 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105 System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) +42 System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +83 System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +160 System.Web.UI.WebControls.Login.AttemptLogin() +105 System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +99 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +115 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +163 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
|||It is a connection failure, if you're using SQL2000 you need to make sure TCP/IP and Named Pipes network libraries are enabled on the SQL2000 instance via Server Network Utility; in case of SQL2005/Express you can enable the remote connecitons using SQL Server Surface Area. Then rewrite your connection string to point to the correct SQL instance.
If you're using built-in Login Controls (membership provider) in .NET 2.0, you can customize the database connections as mentioned in this article:
http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx
sqlFriday, March 23, 2012
Microsoft Ole db provider for Olap services 8.0
Hello Folks,
I am desperately trying to connect to AS using this provider. But when i attempt to connect to it using the UDL file i get the error message - "Provider is no longer available. Ensure that the provider is installed properly."
I have tried re-registering the files msolap80.dll and msmddo80.dll, but to no success.
thanks and have a great day!
Try installing "Microsoft SQL Server 2000 PivotTable Services " from http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Monday, March 19, 2012
Microsoft Access Security
I HAVE CREATED A SECURITY DATABASE USING A NEW WORKGROUP FILE WITH A NEW MDW FILE NAME. THE DATABASE ITSELF CONTAINS SEVERAL GROUPS OF USERS AND SEVERAL USERS. THE DATABASE WORKS AS DESIGNED.
THE PROBLEMS IS IF I OPEN THIS DATABASE USING THE SYSTEM.MDW FILE, THE DATABASE OPENS AND GIVE ME COMPLETE ACCESS TO EVERYTHING.
CAN ANYONE EXPLAIN WHAT IS HAPPENING.
ANY HELP WILL BE APPRECIATED
THANKING YOU IN ADVANCE
JOSEPH FORDDid you give the user Admin a password?
Did you join to the workgroup?|||Originally posted by Brett Kaiser
Did you give the user Admin a password?
Did you join to the workgroup?
I gave the admin a password and then created a new administer with a different name.
When I open the database with the workgroup I created it works fine.
but when I open the database with the system.mdw workgroup it allow me to enter the database. which should not be. I am missing something.
Thanks|||And it doesn't ask you for a password, right?|||Originally posted by Brett Kaiser
And it doesn't ask you for a password, right?
Yes that is correct. The following information I found in Q/A section. What do you make of this.
10. Additionally, you may need manually to remove the Open/Run permission from the database container for the Users group through the security menus or through code. This will prevent someone from opening the database by using another workgroup information file or the default System.mda/mdw. In Microsoft Access 97, the User Level Security Wizard is supposed to remove the Open/Run database permissions for the Users group, but fails to do so. The Access 2000 Security Wizard removes permissions to the point where they are not visible on the security menus, but testing has revealed that in Access 2000 it is possible to open a database by using the default workgroup information file regardless of the menu settings. The cure for both versions of Access is to create a new, empty database while logged on as a member of the Admins group and import all of the objects from the secured database. You should take this step before spending too much time securing objects because Access considers imported objects to be new and loses the permission information that was stored in the source database.|||Yeah..it's a toy...
Don't use the default workgroup...
But you said you removed all of the permissions from Admin (that's what it's opening with), but it doesn't seem to be the case...
You sure your removed Admin from the Admin group?
And made sure it had no permissions?|||Originally posted by Brett Kaiser
Yeah..it's a toy...
Don't use the default workgroup...
But you said you removed all of the permissions from Admin (that's what it's opening with), but it doesn't seem to be the case...
You sure your removed Admin from the Admin group?
And made sure it had no permissions?
I think I have but could be wrong. I have attached a file that I would appreciate your looking at to see if you can see the problelm.
Thanks for your help
Joe Ford|||I think you forgot the attachment...|||Originally posted by Brett Kaiser
I think you forgot the attachment...
Your are right. I have attached it now. Please forgive my senior memo.|||OK,
How about what he permissions are fopr the user group...|||Originally posted by Brett Kaiser
OK,
How about what he permissions are fopr the user group...
ALL USERS ARE PART OF THE USER GROUP AND THAT GROUP HAS NO PERMISSION AT ALL INCLUDING ADMIN.|||Yeah...I figured as much...
Who is the owner of all the objects...Where they all originally created by Admin?|||Originally posted by Brett Kaiser
Yeah...I figured as much...
Who is the owner of all the objects...Where they all originally created by Admin?
Owner is Poweradmin see attached|||What about the other objects (like tables, macros, ect)...don't know if dbowner does it...I think it should...
who owns them?|||Originally posted by Brett Kaiser
What about the other objects (like tables, macros, ect)...don't know if dbowner does it...I think it should...
who owns them?
they are all owned by poweradmin|||Make sure u encrypt ur database using workgroup information file
Also inform u are whitout knowing that even if u create particular
security file for an access database .. .Users group which is default to any *.mdw file will be created and access won't allow u to delete it ...
however make sure you didn't grant any permission to this group
regards ...
THE PROBLEMS IS IF I OPEN THIS DATABASE USING THE SYSTEM.MDW FILE, THE DATABASE OPENS AND GIVE ME COMPLETE ACCESS TO EVERYTHING.
CAN ANYONE EXPLAIN WHAT IS HAPPENING.
ANY HELP WILL BE APPRECIATED
THANKING YOU IN ADVANCE
JOSEPH FORDDid you give the user Admin a password?
Did you join to the workgroup?|||Originally posted by Brett Kaiser
Did you give the user Admin a password?
Did you join to the workgroup?
I gave the admin a password and then created a new administer with a different name.
When I open the database with the workgroup I created it works fine.
but when I open the database with the system.mdw workgroup it allow me to enter the database. which should not be. I am missing something.
Thanks|||And it doesn't ask you for a password, right?|||Originally posted by Brett Kaiser
And it doesn't ask you for a password, right?
Yes that is correct. The following information I found in Q/A section. What do you make of this.
10. Additionally, you may need manually to remove the Open/Run permission from the database container for the Users group through the security menus or through code. This will prevent someone from opening the database by using another workgroup information file or the default System.mda/mdw. In Microsoft Access 97, the User Level Security Wizard is supposed to remove the Open/Run database permissions for the Users group, but fails to do so. The Access 2000 Security Wizard removes permissions to the point where they are not visible on the security menus, but testing has revealed that in Access 2000 it is possible to open a database by using the default workgroup information file regardless of the menu settings. The cure for both versions of Access is to create a new, empty database while logged on as a member of the Admins group and import all of the objects from the secured database. You should take this step before spending too much time securing objects because Access considers imported objects to be new and loses the permission information that was stored in the source database.|||Yeah..it's a toy...
Don't use the default workgroup...
But you said you removed all of the permissions from Admin (that's what it's opening with), but it doesn't seem to be the case...
You sure your removed Admin from the Admin group?
And made sure it had no permissions?|||Originally posted by Brett Kaiser
Yeah..it's a toy...
Don't use the default workgroup...
But you said you removed all of the permissions from Admin (that's what it's opening with), but it doesn't seem to be the case...
You sure your removed Admin from the Admin group?
And made sure it had no permissions?
I think I have but could be wrong. I have attached a file that I would appreciate your looking at to see if you can see the problelm.
Thanks for your help
Joe Ford|||I think you forgot the attachment...|||Originally posted by Brett Kaiser
I think you forgot the attachment...
Your are right. I have attached it now. Please forgive my senior memo.|||OK,
How about what he permissions are fopr the user group...|||Originally posted by Brett Kaiser
OK,
How about what he permissions are fopr the user group...
ALL USERS ARE PART OF THE USER GROUP AND THAT GROUP HAS NO PERMISSION AT ALL INCLUDING ADMIN.|||Yeah...I figured as much...
Who is the owner of all the objects...Where they all originally created by Admin?|||Originally posted by Brett Kaiser
Yeah...I figured as much...
Who is the owner of all the objects...Where they all originally created by Admin?
Owner is Poweradmin see attached|||What about the other objects (like tables, macros, ect)...don't know if dbowner does it...I think it should...
who owns them?|||Originally posted by Brett Kaiser
What about the other objects (like tables, macros, ect)...don't know if dbowner does it...I think it should...
who owns them?
they are all owned by poweradmin|||Make sure u encrypt ur database using workgroup information file
Also inform u are whitout knowing that even if u create particular
security file for an access database .. .Users group which is default to any *.mdw file will be created and access won't allow u to delete it ...
however make sure you didn't grant any permission to this group
regards ...
Monday, March 12, 2012
MHTML Streaming
I am streaming an MHTML file to an aspx page:
Response.Clear()
Response.AddHeader("Content-Disposition", "inline; filename=MyFile.mht")
Response.AddHeader("Content-Length", MyByteArray.Length.ToString)
Response.ContentType = "multipart/related"
Response.BinaryWrite(MyByteArray)
Response.Flush()
When I load the aspx page on my computer with IE... I get "Invalid syntax
error"... when I load the same page... thru HTTP access from a co-worker's
computer... it loads fine... what am I doing wrong?
Not sure if it makes a difference... I had the address bar hidden so I didn't
notice at first... when my co-worker renders the stream the url stays the
same... for me I get mhtml: in front of the url... in addition to the
"invalid syntax" error.I figured I should post this in case other ppl were looking for some
answers... apparently my MHTML issue has something to do with a security
patch for IE... there is however a way to get around it...
You can attach a dummy query string to your aspx page that ends with a .mht.
For example, if the page that streams down mht content is MyPage.aspx, then
you want to use this URL:
http://Path-To-File/MyPage.aspx?ignored=whatever.mht
"MER78" wrote:
> I am streaming an MHTML file to an aspx page:
> Response.Clear()
> Response.AddHeader("Content-Disposition", "inline; filename=MyFile.mht")
> Response.AddHeader("Content-Length", MyByteArray.Length.ToString)
> Response.ContentType = "multipart/related"
> Response.BinaryWrite(MyByteArray)
> Response.Flush()
> When I load the aspx page on my computer with IE... I get "Invalid syntax
> error"... when I load the same page... thru HTTP access from a co-worker's
> computer... it loads fine... what am I doing wrong?
> Not sure if it makes a difference... I had the address bar hidden so I didn't
> notice at first... when my co-worker renders the stream the url stays the
> same... for me I get mhtml: in front of the url... in addition to the
> "invalid syntax" error.
Response.Clear()
Response.AddHeader("Content-Disposition", "inline; filename=MyFile.mht")
Response.AddHeader("Content-Length", MyByteArray.Length.ToString)
Response.ContentType = "multipart/related"
Response.BinaryWrite(MyByteArray)
Response.Flush()
When I load the aspx page on my computer with IE... I get "Invalid syntax
error"... when I load the same page... thru HTTP access from a co-worker's
computer... it loads fine... what am I doing wrong?
Not sure if it makes a difference... I had the address bar hidden so I didn't
notice at first... when my co-worker renders the stream the url stays the
same... for me I get mhtml: in front of the url... in addition to the
"invalid syntax" error.I figured I should post this in case other ppl were looking for some
answers... apparently my MHTML issue has something to do with a security
patch for IE... there is however a way to get around it...
You can attach a dummy query string to your aspx page that ends with a .mht.
For example, if the page that streams down mht content is MyPage.aspx, then
you want to use this URL:
http://Path-To-File/MyPage.aspx?ignored=whatever.mht
"MER78" wrote:
> I am streaming an MHTML file to an aspx page:
> Response.Clear()
> Response.AddHeader("Content-Disposition", "inline; filename=MyFile.mht")
> Response.AddHeader("Content-Length", MyByteArray.Length.ToString)
> Response.ContentType = "multipart/related"
> Response.BinaryWrite(MyByteArray)
> Response.Flush()
> When I load the aspx page on my computer with IE... I get "Invalid syntax
> error"... when I load the same page... thru HTTP access from a co-worker's
> computer... it loads fine... what am I doing wrong?
> Not sure if it makes a difference... I had the address bar hidden so I didn't
> notice at first... when my co-worker renders the stream the url stays the
> same... for me I get mhtml: in front of the url... in addition to the
> "invalid syntax" error.
MgmtStudio: Use current connection/window when opening file
Is there a setting that I am missing, or is it just not possible to do.
When I have a "QueryAnalyzer" Connection/Window open in SQL Server Management Studio, and I open a script file... it wan't to make another connection.
Is there a way that I can set it to NOT do this, and use the existing Window/Connection.
As we have to SQL Logins and thus need to type our passwords each time a new connection is made...
Also, is CTRL-N not in use anymore to open a new connection/window ?
This behavior has been changed in our next service pack (Service Pack 2). There were many Microsoft Connect items filed around this. You can check them out here: http://connect.microsoft.com/SQLServer/.
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
MgmtStudio: Use current connection/window when opening file
Is there a setting that I am missing, or is it just not possible to do.
When I have a "QueryAnalyzer" Connection/Window open in SQL Server Management Studio, and I open a script file... it wan't to make another connection.
Is there a way that I can set it to NOT do this, and use the existing Window/Connection.
As we have to SQL Logins and thus need to type our passwords each time a new connection is made...
Also, is CTRL-N not in use anymore to open a new connection/window ?
This behavior has been changed in our next service pack (Service Pack 2). There were many Microsoft Connect items filed around this. You can check them out here: http://connect.microsoft.com/SQLServer/.
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
Friday, March 9, 2012
Metadata Repository Engine
How do I verify that the Metadata Repository Engine was updated to version
3.0 when I installed SQL 2000. The Help file says that if the engine is at
3.0 that I should be able to upgrade the database to 3.0. The upgrade
button is greyed out and the version is 2.0. I have another instance on the
same physical server (different virtual server) that is running 3.0.
Thanks,
JoelCheck the version for repodbc.dll. It should be version
2000.0.x.x
which corresponds to SQL 2000, repository v. 3.
I thing the v2 engine had the version of the file at
6.10.x.x or 6.0.x.x
You can find more specific info on your version by entering
the file name at the following site:
http://support.microsoft.com/default.aspx?scid=/servicedesks/fileversion/dllinfo.asp
-Sue
On Thu, 2 Oct 2003 10:36:05 -0500, "Joel Donaldson"
<jdonaldson@.centiv.com> wrote:
>How do I verify that the Metadata Repository Engine was updated to version
>3.0 when I installed SQL 2000. The Help file says that if the engine is at
>3.0 that I should be able to upgrade the database to 3.0. The upgrade
>button is greyed out and the version is 2.0. I have another instance on the
>same physical server (different virtual server) that is running 3.0.
>Thanks,
>Joel
>
3.0 when I installed SQL 2000. The Help file says that if the engine is at
3.0 that I should be able to upgrade the database to 3.0. The upgrade
button is greyed out and the version is 2.0. I have another instance on the
same physical server (different virtual server) that is running 3.0.
Thanks,
JoelCheck the version for repodbc.dll. It should be version
2000.0.x.x
which corresponds to SQL 2000, repository v. 3.
I thing the v2 engine had the version of the file at
6.10.x.x or 6.0.x.x
You can find more specific info on your version by entering
the file name at the following site:
http://support.microsoft.com/default.aspx?scid=/servicedesks/fileversion/dllinfo.asp
-Sue
On Thu, 2 Oct 2003 10:36:05 -0500, "Joel Donaldson"
<jdonaldson@.centiv.com> wrote:
>How do I verify that the Metadata Repository Engine was updated to version
>3.0 when I installed SQL 2000. The Help file says that if the engine is at
>3.0 that I should be able to upgrade the database to 3.0. The upgrade
>button is greyed out and the version is 2.0. I have another instance on the
>same physical server (different virtual server) that is running 3.0.
>Thanks,
>Joel
>
Wednesday, March 7, 2012
Metabase Log
We are using MSCRM and my SQL Metabase Log file is 21.3GB and my Metabase
Database file is 18.7MB. How do I clear out the Metabase Log File?
Check the recovery model of the database. If it is in full mode, the
database log file will keep growing, unless you take periodic transaction
log backups.
If you don't need transaction log backups, but simply want to backup the
database once a day or so, switch the database to simple recovery mode.
This can be done from the database properties dialog box in Enterprise
Manager.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"KMD" <KMD@.discussions.microsoft.com> wrote in message
news:9D0CA478-2FAA-4AEA-97B7-C4608637D1F8@.microsoft.com...
We are using MSCRM and my SQL Metabase Log file is 21.3GB and my Metabase
Database file is 18.7MB. How do I clear out the Metabase Log File?
|||My backup strategy is set to Simple for quite some time now. How can I
regain the space that is used in the Metabase Log, it is 21GIG. To backup
the Transaction Log is greyed out, is this because the recovery model is set
to Simple. Any ideas to regain this space.
"Narayana Vyas Kondreddi" wrote:
> Check the recovery model of the database. If it is in full mode, the
> database log file will keep growing, unless you take periodic transaction
> log backups.
> If you don't need transaction log backups, but simply want to backup the
> database once a day or so, switch the database to simple recovery mode.
> This can be done from the database properties dialog box in Enterprise
> Manager.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "KMD" <KMD@.discussions.microsoft.com> wrote in message
> news:9D0CA478-2FAA-4AEA-97B7-C4608637D1F8@.microsoft.com...
> We are using MSCRM and my SQL Metabase Log file is 21.3GB and my Metabase
> Database file is 18.7MB. How do I clear out the Metabase Log File?
>
>
|||Try shrinking the file (DBCC SHRINKFILE).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"KMD" <KMD@.discussions.microsoft.com> wrote in message
news:06A1E21B-0CD9-49E7-A93B-6E50D104D8BC@.microsoft.com...[vbcol=seagreen]
> My backup strategy is set to Simple for quite some time now. How can I
> regain the space that is used in the Metabase Log, it is 21GIG. To backup
> the Transaction Log is greyed out, is this because the recovery model is set
> to Simple. Any ideas to regain this space.
> "Narayana Vyas Kondreddi" wrote:
Database file is 18.7MB. How do I clear out the Metabase Log File?
Check the recovery model of the database. If it is in full mode, the
database log file will keep growing, unless you take periodic transaction
log backups.
If you don't need transaction log backups, but simply want to backup the
database once a day or so, switch the database to simple recovery mode.
This can be done from the database properties dialog box in Enterprise
Manager.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"KMD" <KMD@.discussions.microsoft.com> wrote in message
news:9D0CA478-2FAA-4AEA-97B7-C4608637D1F8@.microsoft.com...
We are using MSCRM and my SQL Metabase Log file is 21.3GB and my Metabase
Database file is 18.7MB. How do I clear out the Metabase Log File?
|||My backup strategy is set to Simple for quite some time now. How can I
regain the space that is used in the Metabase Log, it is 21GIG. To backup
the Transaction Log is greyed out, is this because the recovery model is set
to Simple. Any ideas to regain this space.
"Narayana Vyas Kondreddi" wrote:
> Check the recovery model of the database. If it is in full mode, the
> database log file will keep growing, unless you take periodic transaction
> log backups.
> If you don't need transaction log backups, but simply want to backup the
> database once a day or so, switch the database to simple recovery mode.
> This can be done from the database properties dialog box in Enterprise
> Manager.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "KMD" <KMD@.discussions.microsoft.com> wrote in message
> news:9D0CA478-2FAA-4AEA-97B7-C4608637D1F8@.microsoft.com...
> We are using MSCRM and my SQL Metabase Log file is 21.3GB and my Metabase
> Database file is 18.7MB. How do I clear out the Metabase Log File?
>
>
|||Try shrinking the file (DBCC SHRINKFILE).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"KMD" <KMD@.discussions.microsoft.com> wrote in message
news:06A1E21B-0CD9-49E7-A93B-6E50D104D8BC@.microsoft.com...[vbcol=seagreen]
> My backup strategy is set to Simple for quite some time now. How can I
> regain the space that is used in the Metabase Log, it is 21GIG. To backup
> the Transaction Log is greyed out, is this because the recovery model is set
> to Simple. Any ideas to regain this space.
> "Narayana Vyas Kondreddi" wrote:
Metabase Log
We are using MSCRM and my SQL Metabase Log file is 21.3GB and my Metabase
Database file is 18.7MB. How do I clear out the Metabase Log File?Check the recovery model of the database. If it is in full mode, the
database log file will keep growing, unless you take periodic transaction
log backups.
If you don't need transaction log backups, but simply want to backup the
database once a day or so, switch the database to simple recovery mode.
This can be done from the database properties dialog box in Enterprise
Manager.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"KMD" <KMD@.discussions.microsoft.com> wrote in message
news:9D0CA478-2FAA-4AEA-97B7-C4608637D1F8@.microsoft.com...
We are using MSCRM and my SQL Metabase Log file is 21.3GB and my Metabase
Database file is 18.7MB. How do I clear out the Metabase Log File?|||My backup strategy is set to Simple for quite some time now. How can I
regain the space that is used in the Metabase Log, it is 21GIG. To backup
the Transaction Log is greyed out, is this because the recovery model is set
to Simple. Any ideas to regain this space.
"Narayana Vyas Kondreddi" wrote:
> Check the recovery model of the database. If it is in full mode, the
> database log file will keep growing, unless you take periodic transaction
> log backups.
> If you don't need transaction log backups, but simply want to backup the
> database once a day or so, switch the database to simple recovery mode.
> This can be done from the database properties dialog box in Enterprise
> Manager.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "KMD" <KMD@.discussions.microsoft.com> wrote in message
> news:9D0CA478-2FAA-4AEA-97B7-C4608637D1F8@.microsoft.com...
> We are using MSCRM and my SQL Metabase Log file is 21.3GB and my Metabase
> Database file is 18.7MB. How do I clear out the Metabase Log File?
>
>|||Try shrinking the file (DBCC SHRINKFILE).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"KMD" <KMD@.discussions.microsoft.com> wrote in message
news:06A1E21B-0CD9-49E7-A93B-6E50D104D8BC@.microsoft.com...
> My backup strategy is set to Simple for quite some time now. How can I
> regain the space that is used in the Metabase Log, it is 21GIG. To backup
> the Transaction Log is greyed out, is this because the recovery model is set
> to Simple. Any ideas to regain this space.
> "Narayana Vyas Kondreddi" wrote:
>> Check the recovery model of the database. If it is in full mode, the
>> database log file will keep growing, unless you take periodic transaction
>> log backups.
>> If you don't need transaction log backups, but simply want to backup the
>> database once a day or so, switch the database to simple recovery mode.
>> This can be done from the database properties dialog box in Enterprise
>> Manager.
>> --
>> HTH,
>> Vyas, MVP (SQL Server)
>> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>>
>> "KMD" <KMD@.discussions.microsoft.com> wrote in message
>> news:9D0CA478-2FAA-4AEA-97B7-C4608637D1F8@.microsoft.com...
>> We are using MSCRM and my SQL Metabase Log file is 21.3GB and my Metabase
>> Database file is 18.7MB. How do I clear out the Metabase Log File?
>>
Database file is 18.7MB. How do I clear out the Metabase Log File?Check the recovery model of the database. If it is in full mode, the
database log file will keep growing, unless you take periodic transaction
log backups.
If you don't need transaction log backups, but simply want to backup the
database once a day or so, switch the database to simple recovery mode.
This can be done from the database properties dialog box in Enterprise
Manager.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"KMD" <KMD@.discussions.microsoft.com> wrote in message
news:9D0CA478-2FAA-4AEA-97B7-C4608637D1F8@.microsoft.com...
We are using MSCRM and my SQL Metabase Log file is 21.3GB and my Metabase
Database file is 18.7MB. How do I clear out the Metabase Log File?|||My backup strategy is set to Simple for quite some time now. How can I
regain the space that is used in the Metabase Log, it is 21GIG. To backup
the Transaction Log is greyed out, is this because the recovery model is set
to Simple. Any ideas to regain this space.
"Narayana Vyas Kondreddi" wrote:
> Check the recovery model of the database. If it is in full mode, the
> database log file will keep growing, unless you take periodic transaction
> log backups.
> If you don't need transaction log backups, but simply want to backup the
> database once a day or so, switch the database to simple recovery mode.
> This can be done from the database properties dialog box in Enterprise
> Manager.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "KMD" <KMD@.discussions.microsoft.com> wrote in message
> news:9D0CA478-2FAA-4AEA-97B7-C4608637D1F8@.microsoft.com...
> We are using MSCRM and my SQL Metabase Log file is 21.3GB and my Metabase
> Database file is 18.7MB. How do I clear out the Metabase Log File?
>
>|||Try shrinking the file (DBCC SHRINKFILE).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"KMD" <KMD@.discussions.microsoft.com> wrote in message
news:06A1E21B-0CD9-49E7-A93B-6E50D104D8BC@.microsoft.com...
> My backup strategy is set to Simple for quite some time now. How can I
> regain the space that is used in the Metabase Log, it is 21GIG. To backup
> the Transaction Log is greyed out, is this because the recovery model is set
> to Simple. Any ideas to regain this space.
> "Narayana Vyas Kondreddi" wrote:
>> Check the recovery model of the database. If it is in full mode, the
>> database log file will keep growing, unless you take periodic transaction
>> log backups.
>> If you don't need transaction log backups, but simply want to backup the
>> database once a day or so, switch the database to simple recovery mode.
>> This can be done from the database properties dialog box in Enterprise
>> Manager.
>> --
>> HTH,
>> Vyas, MVP (SQL Server)
>> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>>
>> "KMD" <KMD@.discussions.microsoft.com> wrote in message
>> news:9D0CA478-2FAA-4AEA-97B7-C4608637D1F8@.microsoft.com...
>> We are using MSCRM and my SQL Metabase Log file is 21.3GB and my Metabase
>> Database file is 18.7MB. How do I clear out the Metabase Log File?
>>
Metabase Log
We are using MSCRM and my SQL Metabase Log file is 21.3GB and my Metabase
Database file is 18.7MB. How do I clear out the Metabase Log File?Check the recovery model of the database. If it is in full mode, the
database log file will keep growing, unless you take periodic transaction
log backups.
If you don't need transaction log backups, but simply want to backup the
database once a day or so, switch the database to simple recovery mode.
This can be done from the database properties dialog box in Enterprise
Manager.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"KMD" <KMD@.discussions.microsoft.com> wrote in message
news:9D0CA478-2FAA-4AEA-97B7-C4608637D1F8@.microsoft.com...
We are using MSCRM and my SQL Metabase Log file is 21.3GB and my Metabase
Database file is 18.7MB. How do I clear out the Metabase Log File?|||My backup strategy is set to Simple for quite some time now. How can I
regain the space that is used in the Metabase Log, it is 21GIG. To backup
the Transaction Log is greyed out, is this because the recovery model is set
to Simple. Any ideas to regain this space.
"Narayana Vyas Kondreddi" wrote:
> Check the recovery model of the database. If it is in full mode, the
> database log file will keep growing, unless you take periodic transaction
> log backups.
> If you don't need transaction log backups, but simply want to backup the
> database once a day or so, switch the database to simple recovery mode.
> This can be done from the database properties dialog box in Enterprise
> Manager.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "KMD" <KMD@.discussions.microsoft.com> wrote in message
> news:9D0CA478-2FAA-4AEA-97B7-C4608637D1F8@.microsoft.com...
> We are using MSCRM and my SQL Metabase Log file is 21.3GB and my Metabase
> Database file is 18.7MB. How do I clear out the Metabase Log File?
>
>|||Try shrinking the file (DBCC SHRINKFILE).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"KMD" <KMD@.discussions.microsoft.com> wrote in message
news:06A1E21B-0CD9-49E7-A93B-6E50D104D8BC@.microsoft.com...[vbcol=seagreen]
> My backup strategy is set to Simple for quite some time now. How can I
> regain the space that is used in the Metabase Log, it is 21GIG. To backup
> the Transaction Log is greyed out, is this because the recovery model is s
et
> to Simple. Any ideas to regain this space.
> "Narayana Vyas Kondreddi" wrote:
>
Database file is 18.7MB. How do I clear out the Metabase Log File?Check the recovery model of the database. If it is in full mode, the
database log file will keep growing, unless you take periodic transaction
log backups.
If you don't need transaction log backups, but simply want to backup the
database once a day or so, switch the database to simple recovery mode.
This can be done from the database properties dialog box in Enterprise
Manager.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"KMD" <KMD@.discussions.microsoft.com> wrote in message
news:9D0CA478-2FAA-4AEA-97B7-C4608637D1F8@.microsoft.com...
We are using MSCRM and my SQL Metabase Log file is 21.3GB and my Metabase
Database file is 18.7MB. How do I clear out the Metabase Log File?|||My backup strategy is set to Simple for quite some time now. How can I
regain the space that is used in the Metabase Log, it is 21GIG. To backup
the Transaction Log is greyed out, is this because the recovery model is set
to Simple. Any ideas to regain this space.
"Narayana Vyas Kondreddi" wrote:
> Check the recovery model of the database. If it is in full mode, the
> database log file will keep growing, unless you take periodic transaction
> log backups.
> If you don't need transaction log backups, but simply want to backup the
> database once a day or so, switch the database to simple recovery mode.
> This can be done from the database properties dialog box in Enterprise
> Manager.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "KMD" <KMD@.discussions.microsoft.com> wrote in message
> news:9D0CA478-2FAA-4AEA-97B7-C4608637D1F8@.microsoft.com...
> We are using MSCRM and my SQL Metabase Log file is 21.3GB and my Metabase
> Database file is 18.7MB. How do I clear out the Metabase Log File?
>
>|||Try shrinking the file (DBCC SHRINKFILE).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"KMD" <KMD@.discussions.microsoft.com> wrote in message
news:06A1E21B-0CD9-49E7-A93B-6E50D104D8BC@.microsoft.com...[vbcol=seagreen]
> My backup strategy is set to Simple for quite some time now. How can I
> regain the space that is used in the Metabase Log, it is 21GIG. To backup
> the Transaction Log is greyed out, is this because the recovery model is s
et
> to Simple. Any ideas to regain this space.
> "Narayana Vyas Kondreddi" wrote:
>
Saturday, February 25, 2012
messages.sql error during upgrade
I found the solution to this on Microsoft's site.
http://support.microsoft.com/?scid=kb;en-us;Q300676
But I can't download the file s80305i.exe , can anyone send me this file
please ?
Thank you,
FulyaHi Funda,
I tried to send it to your e-mail account with removing nospam stuff from yo
ur e-mail address.
Hope you'll get it..
Umut Nazl?ca, (MCSE 2000/NT; MCDBA; MCSA; MCP+I)|||Thank you so much but it didn't pass our spam filter. If I give you an ftp ,
can you please put it there'
Fulya
"Umut Nazlica" <anonymous@.discussions.microsoft.com> wrote in message
news:4A4F6755-768F-4079-ADAE-E8DF09449BB5@.microsoft.com...
> Hi Funda,
> I tried to send it to your e-mail account with removing nospam stuff from
your e-mail address.
> Hope you'll get it..
> Umut Nazlica, (MCSE 2000/NT; MCDBA; MCSA; MCP+I)
>|||It didn't pass our spam filter.You can send it also to the following
address;
fulyaerol888@.hotmail.com
Thank you.
Fulya
"Umut Nazlica" <anonymous@.discussions.microsoft.com> wrote in message
news:4A4F6755-768F-4079-ADAE-E8DF09449BB5@.microsoft.com...
> Hi Funda,
> I tried to send it to your e-mail account with removing nospam stuff from
your e-mail address.
> Hope you'll get it..
> Umut Nazlica, (MCSE 2000/NT; MCDBA; MCSA; MCP+I)
>|||Hi,
i send it to your hotmail account..|||Hi Umut,
I couldn't receive it also at my hotmail account. I need that file badly.
can you please send it to my ftp account? I would appreciate it so much.Can
you please send me your email address so that I can send you the ftp info?
Thank you.
Fulya
"Umut Nazlica" <anonymous@.discussions.microsoft.com> wrote in message
news:38C89CCE-2937-4B28-BCE2-E8A0CE413867@.microsoft.com...
> Hi,
> i send it to your hotmail account..
>|||Hi,
I wasn't at my desk for a while.
You can send your ftp info to umutn@.hotmail.com (if you're still looking for
the file.)
http://support.microsoft.com/?scid=kb;en-us;Q300676
But I can't download the file s80305i.exe , can anyone send me this file
please ?
Thank you,
FulyaHi Funda,
I tried to send it to your e-mail account with removing nospam stuff from yo
ur e-mail address.
Hope you'll get it..
Umut Nazl?ca, (MCSE 2000/NT; MCDBA; MCSA; MCP+I)|||Thank you so much but it didn't pass our spam filter. If I give you an ftp ,
can you please put it there'
Fulya
"Umut Nazlica" <anonymous@.discussions.microsoft.com> wrote in message
news:4A4F6755-768F-4079-ADAE-E8DF09449BB5@.microsoft.com...
> Hi Funda,
> I tried to send it to your e-mail account with removing nospam stuff from
your e-mail address.
> Hope you'll get it..
> Umut Nazlica, (MCSE 2000/NT; MCDBA; MCSA; MCP+I)
>|||It didn't pass our spam filter.You can send it also to the following
address;
fulyaerol888@.hotmail.com
Thank you.
Fulya
"Umut Nazlica" <anonymous@.discussions.microsoft.com> wrote in message
news:4A4F6755-768F-4079-ADAE-E8DF09449BB5@.microsoft.com...
> Hi Funda,
> I tried to send it to your e-mail account with removing nospam stuff from
your e-mail address.
> Hope you'll get it..
> Umut Nazlica, (MCSE 2000/NT; MCDBA; MCSA; MCP+I)
>|||Hi,
i send it to your hotmail account..|||Hi Umut,
I couldn't receive it also at my hotmail account. I need that file badly.
can you please send it to my ftp account? I would appreciate it so much.Can
you please send me your email address so that I can send you the ftp info?
Thank you.
Fulya
"Umut Nazlica" <anonymous@.discussions.microsoft.com> wrote in message
news:38C89CCE-2937-4B28-BCE2-E8A0CE413867@.microsoft.com...
> Hi,
> i send it to your hotmail account..
>|||Hi,
I wasn't at my desk for a while.
You can send your ftp info to umutn@.hotmail.com (if you're still looking for
the file.)
Monday, February 20, 2012
message box in rdl
hi everybody
i m using dynamic connection in rdl file firstly i m showing username and pwd . after this user name and pwd i make a connection string for my report. when i m entering invalid pwd, than report generate an error. and stop. is there any way by which i can trace error and flash a message box to user about his invalid user name or pwd.
thanks
If you use the report viewer controls, you can trap the ReportError event in your code. Otherwise, the error message will always be embedded in the report.Merging, and loading dynamic flat file.
I have number of csv files in a folder, all of them with same columns, need to be merged into one table and imported to sql server.
-The first row of the csv file is a header.
-The csv files are updated everyday
-The destination table is replace by new table with new info in the csv.
-The new csv files can be created and old csv files may no longer exist, but we are only interested in information contain in current csv files in the folder.
-I need SSIS to combine all the csv files in the folder and merge into one table.
-Other issue is that the field names may change in csv, so can the SSIS package recognize the change in field name and made necessary change in destination table as well.
Any insight on this issues will be greatly appreciated?
Put simply this is not a scenario that SSIS supports. The key problem is the dynamic nature of the file structure, which SSIS has no run-time support for. The target scenarios for SSIS revolve around unattended/automated data transfer, and any kind of dynamic format is just never going to work well with SSIS.
What use would a new table be that the system has never seen before? For you, you obviously then interpret this, but unless you tell SSIS to do that up front, it would never make sense for it.
Subscribe to:
Posts (Atom)