mssql & msaccess .mdb file with database password

i get daily updated .mdb file from another office.
i have mssql as b/e and msaccess as f/e.
the .mdb file i get daily has a database password,
and i am looking for ways to access the .mdb file through my sql server.
(i want to upload the file to the sql server not having to remove the
password manually daily)
i want to use either
1. use addlinkedserver sp or
2. use openrowset()
can anyone tell me the syntax of either of these in order to supply the
msaccess database password?
TIA.
*** Sent via Developersdex http://www.codecomments.com ***
http://www.connectionstrings.com has good examples of many types of
connection strings. It looks like an ODBC connection with an Access
database can be established by using the "Microsoft OLE DB Provider for
ODBC Drivers" with a provider string like this (without the quotes):
"Driver={Microsoft Access Driver
(*.mdb)};Dbq=C:\mydatabase.mdb;Uid=xxx;Pwd=xxx;"
Good luck,
Tony Sebion
"paul a" <paul@.gii.co.jp> wrote in message
news:#mOfQPStFHA.4076@.TK2MSFTNGP11.phx.gbl:

> i get daily updated .mdb file from another office.
> i have mssql as b/e and msaccess as f/e.
> the .mdb file i get daily has a database password,
> and i am looking for ways to access the .mdb file through my sql server.
> (i want to upload the file to the sql server not having to remove the
> password manually daily)
> i want to use either
> 1. use addlinkedserver sp or
> 2. use openrowset()
> can anyone tell me the syntax of either of these in order to supply the
> msaccess database password?
> TIA.
>
> *** Sent via Developersdex http://www.codecomments.com ***

mssql & msaccess .mdb file with database password

i get daily updated .mdb file from another office.
i have mssql as b/e and msaccess as f/e.
the .mdb file i get daily has a database password,
and i am looking for ways to access the .mdb file through my sql server.
(i want to upload the file to the sql server not having to remove the
password manually daily)
i want to use either
1. use addlinkedserver sp or
2. use openrowset()
can anyone tell me the syntax of either of these in order to supply the
msaccess database password?
TIA.
*** Sent via Developersdex http://www.codecomments.com ***http://www.connectionstrings.com has good examples of many types of
connection strings. It looks like an ODBC connection with an Access
database can be established by using the "Microsoft OLE DB Provider for
ODBC Drivers" with a provider string like this (without the quotes):
"Driver={Microsoft Access Driver
(*.mdb)};Dbq=C:\mydatabase.mdb;Uid=xxx;Pwd=xxx;"
Good luck,
Tony Sebion
"paul a" <paul@.gii.co.jp> wrote in message
news:#mOfQPStFHA.4076@.TK2MSFTNGP11.phx.gbl:

> i get daily updated .mdb file from another office.
> i have mssql as b/e and msaccess as f/e.
> the .mdb file i get daily has a database password,
> and i am looking for ways to access the .mdb file through my sql server.
> (i want to upload the file to the sql server not having to remove the
> password manually daily)
> i want to use either
> 1. use addlinkedserver sp or
> 2. use openrowset()
> can anyone tell me the syntax of either of these in order to supply the
> msaccess database password?
> TIA.
>
> *** Sent via Developersdex http://www.codecomments.com ***

MSResultSetGenerator does not work any more

I try to generate a typed result set. I first added a new data source to my project and then changed the custom tool property of the .xsd file from MSDataSetGenerator to MSResultSetGenerator. This was working a few days ago, but recently, it stopped working. I now get the following error when I right click on my .xsd and then "run custom tool":

Error 102 Custom tool error: Failed to generate code. Illegal characters in path. C:\Users\Mathias\Documents\Visual Studio 2005\Projects\WindowsApplication9\WindowsApplication9\NorthwindDataSet1.xsd 1 1 WindowsApplication9

I tried this in several projects, for example I created a new WinForms project and then just added the norhwind.sdf sample database.

I use Visual Studio 2005 + SP1 + SP1 Vista patch (beta) + SQL Compact Edition + ADO .NET Sync Services CTP on Vista Ultimate.

Things I tried to repair this so far:
- VS2005 repair setup
- Reinstalled SQL Compact Edition
- Reinstalled ADO .NET Sync Services
- Reinstalled VS2005 SP1

I have the same problem and it seems that when I try to generate the data source with an empty sql mobile database it works.

When I add tables to the database it does not.

This suggest to me that it must have something to do with the naming conventions of the database tables and/or fields. I'm trying that next.

Did you make any progress? Please report

|||Just as a thought - have you tried running VS2005 as administrator and see if you have the same issue. Be warned VS2005 under Vista is still not officially supported as they haven't released the update yet - the beta fixes some, but definitely not all the Vista related issues.|||Thanks, but I'm already running VS as admin.|||Mathias - I now have the same configuration with you and I am experiencing the same issues. It appears the updates do not play well with the designer (at least under Vista).|||Thanks for testing this. Looks like I have to wait for the final VS Vista upgrade or use it in a VPC with XP.

MSResultSetGenerator does not work any more

I try to generate a typed result set. I first added a new data source to my project and then changed the custom tool property of the .xsd file from MSDataSetGenerator to MSResultSetGenerator. This was working a few days ago, but recently, it stopped working. I now get the following error when I right click on my .xsd and then "run custom tool":

Error 102 Custom tool error: Failed to generate code. Illegal characters in path. C:\Users\Mathias\Documents\Visual Studio 2005\Projects\WindowsApplication9\WindowsApplication9\NorthwindDataSet1.xsd 1 1 WindowsApplication9

I tried this in several projects, for example I created a new WinForms project and then just added the norhwind.sdf sample database.

I use Visual Studio 2005 + SP1 + SP1 Vista patch (beta) + SQL Compact Edition + ADO .NET Sync Services CTP on Vista Ultimate.

Things I tried to repair this so far:
- VS2005 repair setup
- Reinstalled SQL Compact Edition
- Reinstalled ADO .NET Sync Services
- Reinstalled VS2005 SP1

I have the same problem and it seems that when I try to generate the data source with an empty sql mobile database it works.

When I add tables to the database it does not.

This suggest to me that it must have something to do with the naming conventions of the database tables and/or fields. I'm trying that next.

Did you make any progress? Please report

|||Just as a thought - have you tried running VS2005 as administrator and see if you have the same issue. Be warned VS2005 under Vista is still not officially supported as they haven't released the update yet - the beta fixes some, but definitely not all the Vista related issues.|||Thanks, but I'm already running VS as admin.|||Mathias - I now have the same configuration with you and I am experiencing the same issues. It appears the updates do not play well with the designer (at least under Vista).|||Thanks for testing this. Looks like I have to wait for the final VS Vista upgrade or use it in a VPC with XP.

msp files in the MSDE 2000 Release A

Hi there,
After downloading MSDE2000A.exe and extacting the files,
in the Setup folder there are 16 msi files for instances,
a cab file and 17 msp files. I didn't find anything in the
ReadMeMSDE2000A.htm file about these msp files. Are they
used to patch a MSDE 2000 release A instance immediately
after installing it or are they for older versions of MSDE?
Thank you, I appreciate your help,
GDD1499
Hi,
The msp files are the Microsoft Installer Patch files. They are the Patch
Packages that are applied after the setup.
Each .msi file is a separate package that allows you to install an instance
of the Desktop Engine. And therefore there is a corresponding Path File for
each msi file.
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi Ashish,
Thank you for your reply.
So, if I use any of the 16 msis to install an MSDE 2000
Release A instance - without using setup.exe - I need to
patch it immediately using the corresponding patch file?
Do you know what does the patch fix? Or could you point me
to a document that explaines what the patch does.
Thank you,
GDD1499

>--Original Message--
>Hi,
>The msp files are the Microsoft Installer Patch files.
They are the Patch
>Packages that are applied after the setup.
>Each .msi file is a separate package that allows you to
install an instance
>of the Desktop Engine. And therefore there is a
corresponding Path File for
>each msi file.
>
>Ashish
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>.
>
|||Hi,
Yes. You can run any one of the 16 msis to install an instance of MSDE 2000
Release A and need to patch it immediately with the corresponding patch
file.
I am not aware as to what is contained in the patch file. I tried to search
for resources to give details about the patches, but could not locate one.
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.

msmdredir.ini can't open of not a disk file.

Hi all,

I am having one problem about the processing cube in SQL 2005 AS.
when cube runs i get this error in log file:

File system error: Error opening file; \Program Files (x86)\Microsoft SQL Server\90\Shared\ASConfig\msmdredir.ini is not a disk file or file is not accessible.

How can i solve this!!

thanks

Does any one have experienced it before with SSAS! how can i resolve lock issues on this file!!

thanks

|||

This file contains the port numbers used by the SSAS instances on the server. I've never heard of a "locking" issue with it so I'll make a couple general suggestions.

First, try cycling (bouncing) the server to see if that clears the issue. If that doesn't work, try temporarily disabling the SQL Browser service. If this second action clears the problem, I wouldn't recommend leaving that service disabled, but at least you'll have a starting point for tech support.

Bryan Smith

|||

Yes, it's real... I've logged it with PSS and have had it now confirmed as a bug introduced in SP2.

While it revolves around named instances, scheduling the processing to happen at different times per instance may not work for you.

From the testing I did prior to logging the call, I found two issues that were introduced with SP2. Together they make the issue very very painful.

1) When you process a database when SP2 is installed, the AS Instance requires Read/write access to the msdmredir.ini file. Prior to SP2 it didn't. I could even make the file read-only, and the processing would take place successfully.

2) the ini file gets updated approximately every 30 sec PER AS INSTANCE INSTALLED. You can see this by checking the timestamp of the file. So if there are two named instances running, it will update 4 times a min (but not every 15 sec, as the instances have different start times etc). Stopping one or more of the instances will reduce the frequency of the update.

Note that the behaviour described in point 2 above did not start straight away, but only after the first time I tried to synchronise a database from one instance to the next. My thought was that I could do all the processing in one instance, then sync it out to the other instances, and avoid the locking issue. But once the behaviour starts, it doesn't go away thereafter.

So, it means that even if you're only processing from one instance, this issue may get you!! If you're lucky and your ini file isn't continuously updating, scheduling each instance to a different time may work.

Regards,

Andrew

msi did not install ADS wizard

I ran the msi file but thereis no ADS wizard on my programs list, even after a reboot. When I run it again it does a repair but there is still no program. How do I find the right cab file for my device (DellAxim X51 With WM2005)

Is there a way to identify the wizard in C:\programs?

See this page for folder location, there is also a readme.doc file available

http://www.microsoft.com/downloads/details.aspx?FamilyId=B967347A-5DD0-445C-8A9F-AEA3DB9EC4BC&displaylang=en

sql

Msg 911, Level 1, State 10, Line 1, Could not locate entry insysdatabases for database

The SharePoint_config log file is getting too big, I want to shrink
it. I find some blog and follow the instructions, but when I execute
it, I got the Msg 911, Level 1, State 10, Line 1 error
Here is what I did:
C:\Program Files\Microsoft SQL Server\90\tools\binn > sqlcmd -S \\.
\pipe\mssql$microsoft##ssee\sql\query -E
1> backup log [SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639]
2> to disk = 'd:\sharepoint\config.bak'
3> go
Msg 911, Level 1, State 10, Server JITTERBUG\microsoft##ssee, Line 1
Could not locate entry in sysdatabases for database
'SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639'
No entry found with that name. Make sure that the name is entered
correctly.
Msg 3013, Level 16, State 1, Server JITTERBUG\microsoft##ssee, Line 1
Backup log is terminating abnormally.
Can you help? Thanks.
Aaron
Hi
I have never seen the name pipe connection in the server parameter for
SQLCMD but it seems to work!! It would be easier to do something like
nplocal) though!!
The error message says that it can find the database in sysdatabases and
that seems to be the issue.
Try
SELECT Name FROM master..sysdatabases where NAME LIKE 'SharePoint_config%'
to get the name
John
<achan@.rosewater.com> wrote in message
news:3876feb7-df80-4b77-ba38-487da8f57257@.62g2000hsn.googlegroups.com...
> The SharePoint_config log file is getting too big, I want to shrink
> it. I find some blog and follow the instructions, but when I execute
> it, I got the Msg 911, Level 1, State 10, Line 1 error
> Here is what I did:
> C:\Program Files\Microsoft SQL Server\90\tools\binn > sqlcmd -S \\.
> \pipe\mssql$microsoft##ssee\sql\query -E
> 1> backup log [SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639]
> 2> to disk = 'd:\sharepoint\config.bak'
> 3> go
> Msg 911, Level 1, State 10, Server JITTERBUG\microsoft##ssee, Line 1
> Could not locate entry in sysdatabases for database
> 'SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639'
> No entry found with that name. Make sure that the name is entered
> correctly.
> Msg 3013, Level 16, State 1, Server JITTERBUG\microsoft##ssee, Line 1
> Backup log is terminating abnormally.
> Can you help? Thanks.
> Aaron
|||Yes, I use the select name from sysdatabases and it display the name. I also
look into the c:\windows\sysmsi\ssee\mssql.2005\mssql\data where it reside
and the file name is there.
"Tibor Karaszi" wrote:

> The backup command tries to backup a database named
> "SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639". Do you have such database? If not, specify
> the correct database name for the backup command.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> <achan@.rosewater.com> wrote in message
> news:3876feb7-df80-4b77-ba38-487da8f57257@.62g2000hsn.googlegroups.com...
>
|||I did that and it did display the file name.
"John Bell" wrote:

> Hi
> I have never seen the name pipe connection in the server parameter for
> SQLCMD but it seems to work!! It would be easier to do something like
> nplocal) though!!
> The error message says that it can find the database in sysdatabases and
> that seems to be the issue.
> Try
> SELECT Name FROM master..sysdatabases where NAME LIKE 'SharePoint_config%'
> to get the name
> John
>
> <achan@.rosewater.com> wrote in message
> news:3876feb7-df80-4b77-ba38-487da8f57257@.62g2000hsn.googlegroups.com...
>
>
|||Thanks Tibor.
"Tibor Karaszi" wrote:

> Then There's probably something special with the SQL Server that comes with SharePoint (assuming
> that you are 100% positive of the correct database name and that you connected to the correct SQL
> Server instance). You might want to try this in a SharePoint group and see if they have some hints.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Aaron" <Aaron@.discussions.microsoft.com> wrote in message
> news:AC3CD1A0-A462-4398-A560-84842EB40433@.microsoft.com...
>
|||Hi
In which case try
SELECT 'backup log [' + name + '] to disk = ''d:\sharepoint\config.bak''
FROM master..sysdatabases where NAME LIKE 'SharePoint_config%'
And the run the command generated in the output.
John
"Aaron" <Aaron@.discussions.microsoft.com> wrote in message
news:005608A7-6260-4D19-BF44-A09A87E4CD90@.microsoft.com...[vbcol=seagreen]
>I did that and it did display the file name.
> "John Bell" wrote:

Msg 911, Level 1, State 10, Line 1, Could not locate entry in

The SharePoint_config log file is getting too big, I want to shrink
it. I find some blog and follow the instructions, but when I execute
it, I got the Msg 911, Level 1, State 10, Line 1 error
Here is what I did:
C:\Program Files\Microsoft SQL Server\90\tools\binn > sqlcmd -S \\.
\pipe\mssql$microsoft##ssee\sql\query -E
1> backup log [SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639]
2> to disk = 'd:\sharepoint\config.bak'
3> go
Msg 911, Level 1, State 10, Server JITTERBUG\microsoft##ssee, Line 1
Could not locate entry in sysdatabases for database
'SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639'
No entry found with that name. Make sure that the name is entered
correctly.
Msg 3013, Level 16, State 1, Server JITTERBUG\microsoft##ssee, Line 1
Backup log is terminating abnormally.
Can you help? Thanks.
AaronThe backup command tries to backup a database named
"SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639". Do you have such database? If not, specify
the correct database name for the backup command.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<achan@.rosewater.com> wrote in message
news:3876feb7-df80-4b77-ba38-487da8f57257@.62g2000hsn.googlegroups.com...
> The SharePoint_config log file is getting too big, I want to shrink
> it. I find some blog and follow the instructions, but when I execute
> it, I got the Msg 911, Level 1, State 10, Line 1 error
> Here is what I did:
> C:\Program Files\Microsoft SQL Server\90\tools\binn > sqlcmd -S \\.
> \pipe\mssql$microsoft##ssee\sql\query -E
> 1> backup log [SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639]
> 2> to disk = 'd:\sharepoint\config.bak'
> 3> go
> Msg 911, Level 1, State 10, Server JITTERBUG\microsoft##ssee, Line 1
> Could not locate entry in sysdatabases for database
> 'SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639'
> No entry found with that name. Make sure that the name is entered
> correctly.
> Msg 3013, Level 16, State 1, Server JITTERBUG\microsoft##ssee, Line 1
> Backup log is terminating abnormally.
> Can you help? Thanks.
> Aaron|||Hi
I have never seen the name pipe connection in the server parameter for
SQLCMD but it seems to work!! It would be easier to do something like
np:(local) though!!
The error message says that it can find the database in sysdatabases and
that seems to be the issue.
Try
SELECT Name FROM master..sysdatabases where NAME LIKE 'SharePoint_config%'
to get the name
John
<achan@.rosewater.com> wrote in message
news:3876feb7-df80-4b77-ba38-487da8f57257@.62g2000hsn.googlegroups.com...
> The SharePoint_config log file is getting too big, I want to shrink
> it. I find some blog and follow the instructions, but when I execute
> it, I got the Msg 911, Level 1, State 10, Line 1 error
> Here is what I did:
> C:\Program Files\Microsoft SQL Server\90\tools\binn > sqlcmd -S \\.
> \pipe\mssql$microsoft##ssee\sql\query -E
> 1> backup log [SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639]
> 2> to disk = 'd:\sharepoint\config.bak'
> 3> go
> Msg 911, Level 1, State 10, Server JITTERBUG\microsoft##ssee, Line 1
> Could not locate entry in sysdatabases for database
> 'SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639'
> No entry found with that name. Make sure that the name is entered
> correctly.
> Msg 3013, Level 16, State 1, Server JITTERBUG\microsoft##ssee, Line 1
> Backup log is terminating abnormally.
> Can you help? Thanks.
> Aaron|||I did that and it did display the file name.
"John Bell" wrote:
> Hi
> I have never seen the name pipe connection in the server parameter for
> SQLCMD but it seems to work!! It would be easier to do something like
> np:(local) though!!
> The error message says that it can find the database in sysdatabases and
> that seems to be the issue.
> Try
> SELECT Name FROM master..sysdatabases where NAME LIKE 'SharePoint_config%'
> to get the name
> John
>
> <achan@.rosewater.com> wrote in message
> news:3876feb7-df80-4b77-ba38-487da8f57257@.62g2000hsn.googlegroups.com...
> > The SharePoint_config log file is getting too big, I want to shrink
> > it. I find some blog and follow the instructions, but when I execute
> > it, I got the Msg 911, Level 1, State 10, Line 1 error
> >
> > Here is what I did:
> >
> > C:\Program Files\Microsoft SQL Server\90\tools\binn > sqlcmd -S \\.
> > \pipe\mssql$microsoft##ssee\sql\query -E
> > 1> backup log [SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639]
> > 2> to disk = 'd:\sharepoint\config.bak'
> > 3> go
> > Msg 911, Level 1, State 10, Server JITTERBUG\microsoft##ssee, Line 1
> > Could not locate entry in sysdatabases for database
> > 'SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639'
> > No entry found with that name. Make sure that the name is entered
> > correctly.
> > Msg 3013, Level 16, State 1, Server JITTERBUG\microsoft##ssee, Line 1
> > Backup log is terminating abnormally.
> >
> > Can you help? Thanks.
> >
> > Aaron
>
>|||Yes, I use the select name from sysdatabases and it display the name. I also
look into the c:\windows\sysmsi\ssee\mssql.2005\mssql\data where it reside
and the file name is there.
"Tibor Karaszi" wrote:
> The backup command tries to backup a database named
> "SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639". Do you have such database? If not, specify
> the correct database name for the backup command.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> <achan@.rosewater.com> wrote in message
> news:3876feb7-df80-4b77-ba38-487da8f57257@.62g2000hsn.googlegroups.com...
> > The SharePoint_config log file is getting too big, I want to shrink
> > it. I find some blog and follow the instructions, but when I execute
> > it, I got the Msg 911, Level 1, State 10, Line 1 error
> >
> > Here is what I did:
> >
> > C:\Program Files\Microsoft SQL Server\90\tools\binn > sqlcmd -S \\.
> > \pipe\mssql$microsoft##ssee\sql\query -E
> > 1> backup log [SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639]
> > 2> to disk = 'd:\sharepoint\config.bak'
> > 3> go
> > Msg 911, Level 1, State 10, Server JITTERBUG\microsoft##ssee, Line 1
> > Could not locate entry in sysdatabases for database
> > 'SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639'
> > No entry found with that name. Make sure that the name is entered
> > correctly.
> > Msg 3013, Level 16, State 1, Server JITTERBUG\microsoft##ssee, Line 1
> > Backup log is terminating abnormally.
> >
> > Can you help? Thanks.
> >
> > Aaron
>|||Then There's probably something special with the SQL Server that comes with SharePoint (assuming
that you are 100% positive of the correct database name and that you connected to the correct SQL
Server instance). You might want to try this in a SharePoint group and see if they have some hints.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Aaron" <Aaron@.discussions.microsoft.com> wrote in message
news:AC3CD1A0-A462-4398-A560-84842EB40433@.microsoft.com...
> Yes, I use the select name from sysdatabases and it display the name. I also
> look into the c:\windows\sysmsi\ssee\mssql.2005\mssql\data where it reside
> and the file name is there.
> "Tibor Karaszi" wrote:
>> The backup command tries to backup a database named
>> "SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639". Do you have such database? If not,
>> specify
>> the correct database name for the backup command.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> <achan@.rosewater.com> wrote in message
>> news:3876feb7-df80-4b77-ba38-487da8f57257@.62g2000hsn.googlegroups.com...
>> > The SharePoint_config log file is getting too big, I want to shrink
>> > it. I find some blog and follow the instructions, but when I execute
>> > it, I got the Msg 911, Level 1, State 10, Line 1 error
>> >
>> > Here is what I did:
>> >
>> > C:\Program Files\Microsoft SQL Server\90\tools\binn > sqlcmd -S \\.
>> > \pipe\mssql$microsoft##ssee\sql\query -E
>> > 1> backup log [SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639]
>> > 2> to disk = 'd:\sharepoint\config.bak'
>> > 3> go
>> > Msg 911, Level 1, State 10, Server JITTERBUG\microsoft##ssee, Line 1
>> > Could not locate entry in sysdatabases for database
>> > 'SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639'
>> > No entry found with that name. Make sure that the name is entered
>> > correctly.
>> > Msg 3013, Level 16, State 1, Server JITTERBUG\microsoft##ssee, Line 1
>> > Backup log is terminating abnormally.
>> >
>> > Can you help? Thanks.
>> >
>> > Aaron
>>|||Thanks Tibor.
"Tibor Karaszi" wrote:
> Then There's probably something special with the SQL Server that comes with SharePoint (assuming
> that you are 100% positive of the correct database name and that you connected to the correct SQL
> Server instance). You might want to try this in a SharePoint group and see if they have some hints.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Aaron" <Aaron@.discussions.microsoft.com> wrote in message
> news:AC3CD1A0-A462-4398-A560-84842EB40433@.microsoft.com...
> > Yes, I use the select name from sysdatabases and it display the name. I also
> > look into the c:\windows\sysmsi\ssee\mssql.2005\mssql\data where it reside
> > and the file name is there.
> >
> > "Tibor Karaszi" wrote:
> >
> >> The backup command tries to backup a database named
> >> "SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639". Do you have such database? If not,
> >> specify
> >> the correct database name for the backup command.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://sqlblog.com/blogs/tibor_karaszi
> >>
> >>
> >> <achan@.rosewater.com> wrote in message
> >> news:3876feb7-df80-4b77-ba38-487da8f57257@.62g2000hsn.googlegroups.com...
> >> > The SharePoint_config log file is getting too big, I want to shrink
> >> > it. I find some blog and follow the instructions, but when I execute
> >> > it, I got the Msg 911, Level 1, State 10, Line 1 error
> >> >
> >> > Here is what I did:
> >> >
> >> > C:\Program Files\Microsoft SQL Server\90\tools\binn > sqlcmd -S \\.
> >> > \pipe\mssql$microsoft##ssee\sql\query -E
> >> > 1> backup log [SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639]
> >> > 2> to disk = 'd:\sharepoint\config.bak'
> >> > 3> go
> >> > Msg 911, Level 1, State 10, Server JITTERBUG\microsoft##ssee, Line 1
> >> > Could not locate entry in sysdatabases for database
> >> > 'SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639'
> >> > No entry found with that name. Make sure that the name is entered
> >> > correctly.
> >> > Msg 3013, Level 16, State 1, Server JITTERBUG\microsoft##ssee, Line 1
> >> > Backup log is terminating abnormally.
> >> >
> >> > Can you help? Thanks.
> >> >
> >> > Aaron
> >>
> >>
>|||Hi
In which case try
SELECT 'backup log [' + name + '] to disk = ''d:\sharepoint\config.bak''
FROM master..sysdatabases where NAME LIKE 'SharePoint_config%'
And the run the command generated in the output.
John
"Aaron" <Aaron@.discussions.microsoft.com> wrote in message
news:005608A7-6260-4D19-BF44-A09A87E4CD90@.microsoft.com...
>I did that and it did display the file name.
> "John Bell" wrote:
>> Hi
>> I have never seen the name pipe connection in the server parameter for
>> SQLCMD but it seems to work!! It would be easier to do something like
>> np:(local) though!!
>> The error message says that it can find the database in sysdatabases and
>> that seems to be the issue.
>> Try
>> SELECT Name FROM master..sysdatabases where NAME LIKE
>> 'SharePoint_config%'
>> to get the name
>> John
>>
>> <achan@.rosewater.com> wrote in message
>> news:3876feb7-df80-4b77-ba38-487da8f57257@.62g2000hsn.googlegroups.com...
>> > The SharePoint_config log file is getting too big, I want to shrink
>> > it. I find some blog and follow the instructions, but when I execute
>> > it, I got the Msg 911, Level 1, State 10, Line 1 error
>> >
>> > Here is what I did:
>> >
>> > C:\Program Files\Microsoft SQL Server\90\tools\binn > sqlcmd -S \\.
>> > \pipe\mssql$microsoft##ssee\sql\query -E
>> > 1> backup log [SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639]
>> > 2> to disk = 'd:\sharepoint\config.bak'
>> > 3> go
>> > Msg 911, Level 1, State 10, Server JITTERBUG\microsoft##ssee, Line 1
>> > Could not locate entry in sysdatabases for database
>> > 'SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639'
>> > No entry found with that name. Make sure that the name is entered
>> > correctly.
>> > Msg 3013, Level 16, State 1, Server JITTERBUG\microsoft##ssee, Line 1
>> > Backup log is terminating abnormally.
>> >
>> > Can you help? Thanks.
>> >
>> > Aaron
>>

Msg 601 AND Msg 1813 on Attach Database...

Hey All,

I'm trying to use OSQL to attach an MDF and LDF file to my MSDE database. The files were originally detached from an SQL Server 7.0 (also MSDE) service and I'm trying to attach them to a computer running MSDE (SQL Server 2k). When I run sp_attach_db I get the following errors:

msg 601, Level 12, State 3, server IQCRAFT04, Line 1
could not continue scan with NOLOCK due to data movement
msg 1813, Level 16, State 3, server IQCRAFT04, Line 1
could not open new database 'M3SQL'. CREATE DATABASE is aborted.
converting database 'M3SQL' from version 534 to the current version 539.
database 'M3SQL' running the upgrade step fropm version 534 to version 535.

Any idea what this means?
I cannot attach these database files to the SQL Server 7.0 database either.

Thanks!

--BenAddendum:

When I try to attach the database to the original SQL 7 computer, I get the following error messge:

Msg 906, Level 22, State 2, Server NIMITZ, Line 1
Could not locate row in sysobjects for system catalog 'Sysobjects' in database 'M3SQL'. This system catalog should exist in all databases. Run DBCC CHECKTABLE on sysobjects in this database.

Thanks,

-Ben|||Why don't you post the code you're executing...|||Sorry, good call.

Here:

sp_attach_db @.dbname = N'M3SQL', @.filename1 = N'C:\MyData\M3SQL.mdf', @.filename2 = N'C:\MyData\M3SQL.ldf'

Thanks,

Ben|||detached from an SQL Server 7.0 (also MSDE) service and I'm trying to attach them to a computer running MSDE (SQL Server 2k).

Sorry just got that...can you do that?

Also BOL say you can only attach a db if it was previously dettached..

why not try and do a restore...

Also where's the dmp or bak file located?

Can you do RESTORE FILELISTONLY on it to confirm the internall file info?|||Hey Brett,

I'm not terribly familiar with SQL Server, so I may be making mistakes I'm not allowed to make but.

1) You can attach a 7.0 database to 2000. In fact, I can do it with an much older version of this database that I detached and backed up.

2) I was under the impression that I restore could only be done if you had previously done an official 'backup' command, which I didn't.

3) I don't know what a dmp or bak file is or where I would find them.

4) I'll try the RESTORE FILELISTONLY command, but I was unaware of it until you mentioned it. Thanks for the tip!

--Ben|||You can attach a SQL 7.0 DB to a SQL 2K instance. I don't think that is the problem here. As a rule of thumb, whenever SQL Server asks for DBCC CHECKTABLE to be run on sysobjects, it is too late. I am afraid you will have to go back to the last good backup of this database. There are ways of getting a DB attached with no log, but sysobjects is firmly in the data portion of the database.|||MCrowley,

I was reaching that conclusion myself. Thankfully this is a dev environment which means no crucial data was lost. What I am upset about losing is my data structure. Any way I can extract that from the files?

Thanks,

Ben|||P.S. -

Hey Guys,

Besides backing up, what regular maintenance should I perform on my database to prevent this sort of thing in the future?

Please bear in mind I don't have Ent. Man. so every I do has to be from the OSQL command line. :)

Thanks,

Ben|||[blidfolded, loaded gun, very dark room]
Last shot...create a db on MSDE called M3SQL

Dettach it

Then try and attach with your code
[/blidfolded, loaded gun, very dark room]|||No luck, thanks anyways though. I've already started re-building from my old copy. Thanks guys for all of the suggestions!

--Ben|||As far as the pro-active maintenance, I generally try to run DBCC checkdb once a week for each DB. Generally on weekends, when there is less traffic.|||Originally posted by benfinkel
P.S. -

Hey Guys,

Besides backing up, what regular maintenance should I perform on my database to prevent this sort of thing in the future?

Please bear in mind I don't have Ent. Man. so every I do has to be from the OSQL command line. :)

Thanks,

Ben

How come yuo don't have the client tools?

I mean, I may be a command line junkie...but that's pushing it...|||Brett,

Believe me, I wish I did.

The Command Tools only come with SQL Server. We don't own SQL Server, instead we're using MSDE.

MSDE is a free version of the SQL Server engine that comes with MS Office and Visual Studio. Access can be used as a front-end command tool, but I'm just learning how to use it as such. In the meantime, when I search for directions on the internet they describe how to do it in either EM or command-line. Not too many examples of how to accomplish these things in Access. It seems that many of these things can't be accomplished in access.

--Ben|||Not yet...hold on...

OK Try this:

http://popularshareware.com/myLittleAdmin-for-MS-SQL-and-MSDE-download-7283.html

And then there's this:

http://www.databasejournal.com/features/mssql/article.php/10894_1494301_2|||Brett,

I love you. Will you marry me?

We'll have to go to Vermont, but it'll work.|||Hey...cut that out...

Besides, I'm spoken for 8-)

GOOD LUCK dude!

msg 4866

I have created a tab delimited text file using MS Foxpro 2.6 for Unix.
The last field on each line is followed only by a linefeed \n.
When I try to use bulk insert I get the message that the 40th (last) field on the line is too long.
I have tried adding a tab after the last field but this makes no difference.
I have added an ! (exclamation mark) after the last field and changed the rowterminator attribute to !\n. Still doesn't work?
I am using sftp to copy the file from the unix system to windows, and there is no change in the size of the file, so I don't think that a carrriage return is being inserted.
Any suggestions?

If I reduce the size of the input file to one record, then the insert works.|||Never mind, I figured it out. Lines have to end with '\r\n' regardless of the fact that the documentation says the default ROWTERMINATOR is '\n'

msg 4820 Bulk insert error -- "Unknown version of format file"

Hi all,

ISSUE:
====================
In SQL 2005 (sp2) I get the following error when preforming a bulk
insert with an associated xml format file:
"Could not bulk insert. Unknown version of format file"

Question:
====================
I am unsure what they mean by "unknown version". Specifically the
format file in question was created using bcp. Also the entire table
scenario was created from a msdn example.

Any ideas? have you seen this before?

NOTE: i can reproduce this issue outside the example but will refer to
msdn considering it is simple and easily reproducible.

Scenario
====================
I can reproduce this error with the BULK INSERT example discussed on
msdn (example A)
http://msdn2.microsoft.com/en-us/library/ms191234.aspx

TO REPRODUCE:

* In short the table structure is:
Person (Age int, FirstName varchar(20), LastName varchar(30))

* Data File Template:
Age<tab>Firstname<tab>Lastname<return>

* xml file format from bcp (and described on msdn)
<?xml version="1.0"?>
<BCPFORMAT
xmlns="http://schemas.microsoft.com/sqlserver/2004/bulkload/format"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<RECORD>
<FIELD ID="1" xsi:type="CharTerm" TERMINATOR="\t"
MAX_LENGTH="12"/>
<FIELD ID="2" xsi:type="CharTerm" TERMINATOR="\t"
MAX_LENGTH="20" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>
<FIELD ID="3" xsi:type="CharTerm" TERMINATOR="\r\n"
MAX_LENGTH="30"
COLLATION="SQL_Latin1_General_CP1_CI_AS"/>
</RECORD>
<ROW>
<COLUMN SOURCE="1" NAME="age" xsi:type="SQLINT"/>
<COLUMN SOURCE="2" NAME="firstname" xsi:type="SQLVARYCHAR"/>
<COLUMN SOURCE="3" NAME="lastname" xsi:type="SQLVARYCHAR"/>
</ROW>
</BCPFORMAT>

* Here is some the actual sql statement that pulls this all together
BULK INSERT mytestnames
FROM 'C:\datatest\exampledata-c.Dat'
WITH (FORMATFILE = 'C:\datatest\examplefmt.Fmt');

Thanks in advanced for any feedback.

Cheers!

Hi,

plz can you show your XML format file "examplefmt.Fmt".

there must be something like this:

examplefmt.Fmt

...

2 SQLCHAR 0 100 "," 2 firstname SQL_Latin1_General_CP1_CI_AS
...

msg 4820 Bulk insert error -- "Unknown version of format file"

Hi all,

ISSUE:
====================
In SQL 2005 (sp2) I get the following error when preforming a bulk
insert with an associated xml format file:
"Could not bulk insert. Unknown version of format file"

Question:
====================
I am unsure what they mean by "unknown version". Specifically the
format file in question was created using bcp. Also the entire table
scenario was created from a msdn example.

Any ideas? have you seen this before?

NOTE: i can reproduce this issue outside the example but will refer to
msdn considering it is simple and easily reproducible.

Scenario
====================
I can reproduce this error with the BULK INSERT example discussed on
msdn (example A)
http://msdn2.microsoft.com/en-us/library/ms191234.aspx

TO REPRODUCE:

* In short the table structure is:
Person (Age int, FirstName varchar(20), LastName varchar(30))

* Data File Template:
Age<tab>Firstname<tab>Lastname<return>

* xml file format from bcp (and described on msdn)
<?xml version="1.0"?>
<BCPFORMAT
xmlns="http://schemas.microsoft.com/sqlserver/2004/bulkload/format"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<RECORD>
<FIELD ID="1" xsi:type="CharTerm" TERMINATOR="\t"
MAX_LENGTH="12"/>
<FIELD ID="2" xsi:type="CharTerm" TERMINATOR="\t"
MAX_LENGTH="20" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>
<FIELD ID="3" xsi:type="CharTerm" TERMINATOR="\r\n"
MAX_LENGTH="30"
COLLATION="SQL_Latin1_General_CP1_CI_AS"/>
</RECORD>
<ROW>
<COLUMN SOURCE="1" NAME="age" xsi:type="SQLINT"/>
<COLUMN SOURCE="2" NAME="firstname" xsi:type="SQLVARYCHAR"/>
<COLUMN SOURCE="3" NAME="lastname" xsi:type="SQLVARYCHAR"/>
</ROW>
</BCPFORMAT>

* Here is some the actual sql statement that pulls this all together
BULK INSERT mytestnames
FROM 'C:\datatest\exampledata-c.Dat'
WITH (FORMATFILE = 'C:\datatest\examplefmt.Fmt');

Thanks in advanced for any feedback.

Cheers!

Hi,

plz can you show your XML format file "examplefmt.Fmt".

there must be something like this:

examplefmt.Fmt

...

2 SQLCHAR 0 100 "," 2 firstname SQL_Latin1_General_CP1_CI_AS
...

Msg (Loading) after db name

I wanted to restore a database to a new location on a different server. I
did a backup to a file and then did a restore of that file onto the new
server. I got a message that the restore was successful, but when I opened
Enterprise Manager the database had "(Loading)" after the database name and
was grayed out. When I tried to select properties it gave me "Error 927:
Database 'wcccu_db' cannot be opened. It is in the middle of a restore."
Can anyone help? Thanks.
DavidSounds like you might have left your database in a state where you can
restore a differential or additional transaction logs. Could you possibly
have restored using the "NORECOVERY" options, or set the "Leave Database
nonoperation...." radio button when doing your restore.
--
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:%23qBVFFmQEHA.1960@.TK2MSFTNGP10.phx.gbl...
> I wanted to restore a database to a new location on a different server. I
> did a backup to a file and then did a restore of that file onto the new
> server. I got a message that the restore was successful, but when I
opened
> Enterprise Manager the database had "(Loading)" after the database name
and
> was grayed out. When I tried to select properties it gave me "Error 927:
> Database 'wcccu_db' cannot be opened. It is in the middle of a restore."
> Can anyone help? Thanks.
> David
>|||Hi,
Execute the below command from query analyzer:-
restore database <dbname> with recovery
Thanks
Hari
MCDBA
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:#qBVFFmQEHA.1960@.TK2MSFTNGP10.phx.gbl...
> I wanted to restore a database to a new location on a different server. I
> did a backup to a file and then did a restore of that file onto the new
> server. I got a message that the restore was successful, but when I
opened
> Enterprise Manager the database had "(Loading)" after the database name
and
> was grayed out. When I tried to select properties it gave me "Error 927:
> Database 'wcccu_db' cannot be opened. It is in the middle of a restore."
> Can anyone help? Thanks.
> David
>

Msg (Loading) after db name

I wanted to restore a database to a new location on a different server. I
did a backup to a file and then did a restore of that file onto the new
server. I got a message that the restore was successful, but when I opened
Enterprise Manager the database had "(Loading)" after the database name and
was grayed out. When I tried to select properties it gave me "Error 927:
Database 'wcccu_db' cannot be opened. It is in the middle of a restore."
Can anyone help? Thanks.
David
Sounds like you might have left your database in a state where you can
restore a differential or additional transaction logs. Could you possibly
have restored using the "NORECOVERY" options, or set the "Leave Database
nonoperation...." radio button when doing your restore.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:%23qBVFFmQEHA.1960@.TK2MSFTNGP10.phx.gbl...
> I wanted to restore a database to a new location on a different server. I
> did a backup to a file and then did a restore of that file onto the new
> server. I got a message that the restore was successful, but when I
opened
> Enterprise Manager the database had "(Loading)" after the database name
and
> was grayed out. When I tried to select properties it gave me "Error 927:
> Database 'wcccu_db' cannot be opened. It is in the middle of a restore."
> Can anyone help? Thanks.
> David
>
|||Hi,
Execute the below command from query analyzer:-
restore database <dbname> with recovery
Thanks
Hari
MCDBA
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:#qBVFFmQEHA.1960@.TK2MSFTNGP10.phx.gbl...
> I wanted to restore a database to a new location on a different server. I
> did a backup to a file and then did a restore of that file onto the new
> server. I got a message that the restore was successful, but when I
opened
> Enterprise Manager the database had "(Loading)" after the database name
and
> was grayed out. When I tried to select properties it gave me "Error 927:
> Database 'wcccu_db' cannot be opened. It is in the middle of a restore."
> Can anyone help? Thanks.
> David
>
|||Yup. That was it...had the "Leave database nonoperation..." radio boxed
checked. Thanks.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Msg (Loading) after db name

I wanted to restore a database to a new location on a different server. I
did a backup to a file and then did a restore of that file onto the new
server. I got a message that the restore was successful, but when I opened
Enterprise Manager the database had "(Loading)" after the database name and
was grayed out. When I tried to select properties it gave me "Error 927:
Database 'wcccu_db' cannot be opened. It is in the middle of a restore."
Can anyone help? Thanks.
DavidSounds like you might have left your database in a state where you can
restore a differential or additional transaction logs. Could you possibly
have restored using the "NORECOVERY" options, or set the "Leave Database
nonoperation...." radio button when doing your restore.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:%23qBVFFmQEHA.1960@.TK2MSFTNGP10.phx.gbl...
> I wanted to restore a database to a new location on a different server. I
> did a backup to a file and then did a restore of that file onto the new
> server. I got a message that the restore was successful, but when I
opened
> Enterprise Manager the database had "(Loading)" after the database name
and
> was grayed out. When I tried to select properties it gave me "Error 927:
> Database 'wcccu_db' cannot be opened. It is in the middle of a restore."
> Can anyone help? Thanks.
> David
>|||Hi,
Execute the below command from query analyzer:-
restore database <dbname> with recovery
Thanks
Hari
MCDBA
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:#qBVFFmQEHA.1960@.TK2MSFTNGP10.phx.gbl...
> I wanted to restore a database to a new location on a different server. I
> did a backup to a file and then did a restore of that file onto the new
> server. I got a message that the restore was successful, but when I
opened
> Enterprise Manager the database had "(Loading)" after the database name
and
> was grayed out. When I tried to select properties it gave me "Error 927:
> Database 'wcccu_db' cannot be opened. It is in the middle of a restore."
> Can anyone help? Thanks.
> David
>|||Yup. That was it...had the "Leave database nonoperation..." radio boxed
checked. Thanks.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

MsDtsSrvr.ini.xml file configration

Hi All,

How to configure MsDtsSrvr.ini.xml file in a active\active cluster.

Regards, Balaji Thiruvenkataraju

Add the named instances in, as per your previous post which I answered would make sense. Why, are you having a problem?

MsDtsSrvr.ini.xml

Does anyone have a copy of this file from a clustered SQL2005 box with SSIS running? I would to see what you have. I cannot seem to get mine to work.

Thanks David

Hi, you probably already have read this, but just to make sure, the following article on clustering, steps 9-14 deal with the config file.

http://msdn2.microsoft.com/en-us/library/ms345193.aspx

If that does not help the some more info is likely needed such as, are you getting any errors? If so, then what? If not then perhaps posting the acutal contents might be good.

Hope that helps.

|||Thanks to all that replied. I have resolved this issue. I had set the registry entry (that tells SSIS where config file resides) one of my nodes on the cluster and not the other..

MSDTC not available

It is possible to copy the data from table to Excel file with
OpenRowset command
When I tried to copy the result set of stored procedure to Excel file
by using this query
Insert into
OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=F:\v1.xls;HDR=YES',
'SELECT * FROM [Sheet1$]')
Exec mysp 'test','testing'
I got the error
Server: Msg 8501, Level 16, State 3, Line 3
MSDTC on server 'SYS7' is unavailable.
What am I missing?
MadhivananFirst, I would check that the Distributed Transaction Controller is on. The
service can be disabled and is, by default, in certain scenarios. I will see
if I can find anything else to help in this situation.
In response, give an idea of the setup you are running under, as that could
affect the answer. Any additional information on what you are doing would
also be useful.
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
***************************
Think Outside the Box!
***************************
"Madhivanan" wrote:

> It is possible to copy the data from table to Excel file with
> OpenRowset command
> When I tried to copy the result set of stored procedure to Excel file
> by using this query
> Insert into
> OPENROWSET('Microsoft.Jet.OLEDB.4.0',
> 'Excel 8.0;Database=F:\v1.xls;HDR=YES',
> 'SELECT * FROM [Sheet1$]')
> Exec mysp 'test','testing'
> I got the error
> Server: Msg 8501, Level 16, State 3, Line 3
> MSDTC on server 'SYS7' is unavailable.
> What am I missing?
>
> Madhivanan
>|||I just want to copy the result set of sp to Excel
I tried it with table and it is working perfectly
I am using SQL Server2000 with Service Pack 4 and Excel version is 2000
Madhivanan|||Still I didnot solve this problem
Any other ideas?
Madhivanan

MS-DOS COPY problem

Hi,
I want to create a batch file which copies existing files in one directory to another directory(actually sub-directories in the second directory) based on the dates they were created using MS-DOS command.
Example:
File A created on Jan-10-03
File B created on Dec-12-97
File A & B are in C:/ drive and when I run the batch file the File A should be copied to d:/Jan & File B should be copied to D:/Dec

Please let me know!
Thanks.Use xp_cmdshell ...|||Could you please elaborate...I am kind of new to the IT field.
Thank you.

Originally posted by snail
Use xp_cmdshell ...|||xp_cmdshell allows you to issue commands to the operating system just as if you were at a DOS prompt. xp_cmdshell must be called from the Master database. Look it up in Books Online for syntax and details.

blindman|||Doing this with CMD commands is going to be tuff. For this type of work I would suggest a scripting language like PERL, PYTHON or even good old qbasic! Of course you could do this with TSQL but this is not always the best solution for system scripting. Knowing one of the above languages will make short work of this kind of task.|||Hi,

another possibility would be an ActiveXScript in a DTS package. For information about working with files in DTS refer to http://www.sqldts.com/default.aspx?292

Bye,
Carsten