Realllly Fundamental...
Jun 9, 2004
Since I'm new to SQL server I feel like I should be able to ask this with a straight face and without ridicule...
I'm trying to change the location of log and data files, I have identified a stored procedure that will do this, but neither the book I have nor the Microsoft Knowledge base mentions where to run the stored procedure from...
From where or what application does one call or execute a stored procedure for admin type tasks???? The article lists command line inputs...but I'm not sure where to run this from.
View 6 Replies
Jul 20, 2005
I am writing SQL data apps using VB.NET 2003, MSDE is being used as theserver.When I create and instance of the server, it has a the formatmachinename/instancenameThis is fine for the developement machine but how does my code connect tothe server when it is on another machine ? When an instance of MSDE is runon the target, it will produce...anotherPCname/instancenameThanks for any help
View 11 Replies
View Related
Dec 8, 2006
I am attempting to import data into SQL 2005 (using the Tasks->Import Data wizard) and get as far as selecting a datasource. My source is ODBC and I am selecting ".NET Framework Data Provider for Odbc" but then get stuck on the connection string... I am attempting to import from 'Relativity Client' which as far as I can tell is an interface to a Cobol database, I have also had this problem importing from FoxPro - how do I come up with a connection string?
I have also tried to create a DTSX package, created the connection to the odbc source, tested ok, then when selecting the connection as a source (datareader source) I get the message 'Cannot acquire a managed connection from the run-time connection manager'...
I have also created a DTS package in SQL2000, upgraded to a 2005 package, this creates a file which after opening cannot be saved 'System.OutOfMemoryException', on my laptop with 2gig physical ram (1.3gig in use), 8gig virtual memory...
This is getting just a little frustrating as the SQL 2000 wizard fetches the data straight in from any data source I have ever tried with no complication whatsoever...
Unfortunately the first training course I can get on is in the middle of January. But I would prefer not to have to install SQL2000 and SQL2005 (SQL2000 for DTS, SQL2005 for reporting) just to get a few reports up and running.
What do I need to do to make SSIS import ODBC data? Or if someone can direct me to a good source (preferably with examples) of how to get SSIS working it would be greatly appreciated.
View 3 Replies
View Related
Jul 20, 2005
Hi all,What are the fundamentals (fundamental functions) that most small tomedium sized organizations that use MS SQL Server 7 or 2000 valuemost?What's your insight?OK, here's my biased definition of small to medium sized organization,annual revenue from 20m to 300m.Thanks.DL
View 2 Replies
View Related
