Recent update: 2008-3-21
605 byte By
nonno at 2008-3-7
I have an InterBase 5 database, which has been registered as an ODBC System Data Source in my Windows 2000. When I try to add it as a linked server in SQL server 2005, the Add Linked Server page make me so frustrated. I can select the ODBC driver, but I don't know how to specify values for the ...
<span>How can I use <font color="#000000" size="2">AttachDbFilename in DbNameDataSet.xsd to access the database in the same directory as the exe file (i.e. the application using it)?</font></span>
I have a stiuation where I need to import data from Excel and of course I'm using DTS to do so. Because the spreadsheets have a variety of datatypes in them, I have to make sure that DTS recognizes certain rows as INT so they will import properly, to do so I add 5 rows of 1's to the top lines ...
SQL Server 2005 express... when i'm trying to connect through SQL Express Manager, i can connect just fine if i use 'localhost\sqlexpress', or [machinename]\sqlexpress, but if i use local\sqlexpress or .\sqlexpress, it times out. i've recently had trouble connecting through VBExpress as ...
258 byte By
PSD at 2008-3-1
I've been trying to make our server to schedully create a backup for our database. The problem is when I'm done with the scheduling and click 'OK', I again open "database">>all task>> back up, all the properties which I entered are all gone.
Was kind of a nice little feature in SQL 2000. Did this go away or has it been renamed...? Thx.
156 byte By
nonno at 2008-2-27
I can't find the ODBC selection in the Data source list of the Import Wizard, so how can I import data from an ODBC data source to SQL Server 2005?
377 byte By
Challe at 2008-2-26
SQL Server Management Studio:When I try to script a view by right clicking on the view and select Script View / as CREATE TO I get the following error:Exception has been thrown by the target of an invocation. (mscorlib)There is already an open DataReader associated with this Command which must ...
244 byte By
Challe at 2008-2-25
Hi, I have a question regarding export / import when you have tables with autonumber (identity) columns as primary surrogate keys. Does export / import retiain the values of these columns so that referential integriy is not broken? Charles
I have an application that was originally built in VS 2003 and was successfully running against SQL Server 2000 and SQL Server 2005 (June CTP). Recently, we migrated to VS 2005 Beta 2 and are running on SQL Server 2005 (June CTP) exclusively. Since the migration, we have some situations where ...
I am developing a program using ms access with an SQL 2000 back end. I am using an odbc connection to access my data. Using this connection, i can only access the tables and views of my database. I am planning to create "Stored procedure" in SQL and connect it to my MS Access program but have ...
Hi there, In SQL Server 2005 How do I export data in certain table through management studio? Thanks, Anu
I have installed Visual Studio 2003 Professional with Visual Studio Tools for Office 2003 and SQL Server 2000 Developer Edition on the same system running XP SP 2. Using the Server Explorer I can see the databases registered to SQL Server and connect to them. I can see the various objects in ...
Is there a tutorial or documentations for the "complete beginner" similar to the one made for VB.net express but for SQL Express? I went over the Visual Web Developer Express tutorial but its only mention about sql was using the 'sqlcmd' command line tool with a copy and paste. What I'm ...
Our configuration : SQL Server 2005 June CTP Enterprise Edition version : 9.00.1187.07OS : Windows 2003The Problem:After configuring Database Mail account and profile, maintenance plan or job generated with the maintenance plan Wizard is unable to send mail.The SQL Agent error log contains ...
When you mouseover Server Explorer nodes such as a table name, a tool tip of this format appears:MSSQL:://MachineName/DatabaseName/dbo/Table/dbo/TableName : OpenIs the specification for this format published? Can it be programmed against or is this for VS internal use only? ...
Hello, I am writing a data-driven application using ADO.NET1.1 and MSDE2000. My question is: After installing the MSDE and database files (*.mdb) on end user's machine, how to prevent end user from getting the table names, designs and relations by some tools, such as SQL Server enterprise ...
I recently Took over as Database Administrator for a Small Mortgage Firm in the Charlotte Area. The Databases have been poorly maintained for the last three years, with issues such as 3Gig Datafiles and 100G Transaction Files. I have backed up all the databases and reset the Transaction Logs to ...
Hi Everyone. Does Business Intelligence Development Studio (BIDS) integrate with the Team Foundation Server? I've read that BIDS is based on VS.NET, but it's a different client than standard VS.NET. Can we setup a Team Foundation Project and integrate the work item lists, check in policies, ...
I need to delete a table using a stored procedure, I tried delete tblname, but didnt do anything It ran normally, but the table didnt desapeared.Thanks for any suggestion on how to delete a SQL table with all its contents from a Stored Procedure. The table is not related to any other ...
Hi, I am using SQL Server 2005 June CTP and having trouble seeing the active subsystems for a given proxy account. I can successfully create a proxy account and assign Activex Script and Operating system (CmdExec) subsystems access to this account. However, when i goto the proxy account and ...
Hi,I am testing SQL Server 2005 June CTP on 32-bit & 64-bit Intel servers and so far SQL Server Management Studio appears to be very slow and response times are very poor (compared to that SQL Server 2000 Enterprise Manager). Are there others that have noticed this performance ...
1185 byte By
Yakoob at 2008-2-15
Hi,I appreciate if some one please help me to solve the following problem SYMPTOMS I am runnning the Setup program to install Microsoft Windows SharePoint Services. After the Setup program is completed successfully, I configure Windows SharePoint Services settings in SharePoint Central ...
I'm about to create a database (SQL Server 2005 Express edition), but can't find any tools in the Visual studio 2005 beta1 kit that lets me do this visually. I found SQL Server Express Manager - but it doesn't seem to be work like i want (setting up the databases and tables, without maually ...
I have a SQL Server Agent job with a step to execute an SSIS package. The package has as one of it's connection managers the Connection Manager For Excel Files. When I run the job it fails every time. I have implemented logging and in the OnError event it states "The AcquireConnection method ...
172 byte By
MirzaT at 2008-2-15
<span id="_ctl0_MainContent_PostFlatView"></span> <span> It's the possible to see which object (table,view,proc) used (not changed) in last year? Thanks.</span>
Hi, I've developed a tsql alert response stored proc. that will kill connections from specified developers if they connect to particular dbs using tools other than ones they are authorized to have. It seems to work well for most applications like Excel and Access, but not for Query Analyzer ...
I would like to use the latest build, but the April CTP is listed, not the June CTP. Is this an oversight, or intentional?
Hi all, I've got some problem to launch DTA, after the connection, I've got this message :=================================== Failed to open a new connection. =================================== Failed to initialize MSDB database for tuning (exit code: -1). (DTAClient) Program Location: at ...
I am getting an error message during the program startup. TITLE: SQL Express Manager Error occurred during application start up sequence. Application will be shut down. For help, click: ...
173 byte By
Qwee at 2008-2-12
Cancelling queries takes longer than it used to in SQL Server 2K Dont know why?... Is it a new feature?<img src="/library/msdn/emoticons/emotion-2.gif" alt="Big Smile" />
I try to configure database mail on SQL Server 2005 (June CTP)All the services are running under the same domain account which has been also added to corporate Exchange server. When creating a database mail account on SQL Server, I check the "SMTP server requires authentication" check box and ...
Hi My instance of SQL Server 2005 is installed on a Win Server 2003 box. I am trying to schedule an SSIS job. I have created a proxy using my NTLogin as Credential. When I run the job, it returns with the following error:Message[298] SQLServer Error: 15404, Could not obtain information about ...
Hi there,We have a production DB.Under allocated space I see the following: total DB space: 720.50 MB used: 641.50 MB free: 79.0 MBtotal tranLOG space: 15,618.68 MB user: 42.78 MB free: 15,575.9 MB Since I see only 79 MB of available space for data. what can I do to increase total DB space? and ...
Hi!Whenever I want to add a new user to a database (any database) in SQL Server 2000, I get the error message: Error 446: Cannot resolve collation conflict for equal to operation. What does collation have to do with adding new users? Especially since SQL Server has been "conducting" itself ...
Hi,My application connects to excel files.I am using this code:dc = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + fileName + ";" + "Extended Properties=\"Excel 8.0;HDR=YES;\""); It works fine on Excel 2000 on all computers. Also it works on some computers with ...
542 byte By
valko at 2008-2-7
Hi ,I install sql 2005 CTP but cannot connect to the server with management studioinstallation was successful and was named instance and under local system accountin event viewer mssql service is running ok, I see even it connects to master dbI can start and stop server with my old sql agent ...
1038 byte By
Aiby at 2008-2-7
I have installed SQL Server Express Edition - ( Down Loaded )There I found only three entries such asSQL Server Configuration ManagerSQL Server Error and Usage ReportingSQL Server Surface Area ConfigurationExpress Managment tool also i down loaded and installed seperatly.. Exp.Management on ...
I have an SSIS Package deployed to an SSIS Package Store on SQL Server 2005 June CTP. The package executes successfully if I right click on it and click "Execute Package". The package also executes successfully through the dtexecui utility. Also, if I execute the package from a command prompt ...
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 ...
When I write SQL command in the editor, I can not find a menu to format my command.<img src="/library/msdn/emoticons/emotion-6.gif" alt="Sad" /> Also the "Format Document" function in VS2005 Beta2 seems do not delete blank rows. <img src="/library/msdn/emoticons/emotion-6.gif" alt="Sad" />
I have downloaded .net,visual basic and sql server components (2005 beta 2)- I had .net 1.0 and no other vb or sql server versions on my machine.- i uninstalled the 1.0 framework and installed the 2.0 beta 2 version- when i tried to install sql server it told me that i either had previous ...
I was just wondering what the diffrences are between NVARCHAR and VARCHAR? When do I use NVARCHAR as opposed to VARCHAR? Thanks, Matthew
After wasting several days trying to get SQL 2005 installed on my test server & to connect to a virgin database (DotNetNuke), I'm reverting to simply using Express. That should be simple, right?! It's even installed with Visual Studio 2005 (June CPT)!Lookoing, the only thing under ...
Has anyone else tried SQL 2005 CTP...the Import/Export Data Wizard DOESN'T have an option for 'Copy objects and data between SQL Server databases'. Microsoft suggests to use the 'Copy Database Wizard' to copy over objects now...fair enough EXCEPT the copy database wizard copies the whole ...
248 byte By
Alle at 2008-2-4
Hallo, June CTP of SQL Server 2005 (NOT SQL Express) ######## Everything deleted from this post by Alle since it has no relevance to the RTM. Unfortunately I can not delete the thread. ########### Alle</P> </P>
Is there a tool similar to FXCop that will check for TSQL ( or just SQL ) errors , ommissions etc and suggest code improvements ? Also, along the same lines, are there client-side JavaScript and VBScript tools similar to FXCop ? Thanks
Hi Guys, What i'm trying here is to run a .bat file containing Osql Command's on the server using asp. Which is Generating Out Of Memory Error. In Detail. This .bat file is having a Osql command to connect to a database with a parameter to run a .sql file and output parameter to give to ...
The Express Manager will not install until after installing Express. One reason is because of a dependency on the SMO dll. Can Express Manager be installed without Express if SMO is installed into the GAC first? Is there a way to avoid installing Express?
please I need some help about how can I get MSDE for VB6 and I want to know how to manage this on th Customer machine