Hi,
I am getting error 1802, CREATE DATABASE failed. Some file
names listed could not be created. Check previous errors.
I have Windows 2000 professional installed on my PC.
I am installing remedy 5.1 that uses MSSQL server 7 and I
am getting the error above on remedy instalation...
Any idea'
ThanksI suggest you talk to the vendor of remedy. SQL Server returned more error
messages and you really need those error messages to see what the problem
is.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Taiser" <anonymous@.discussions.microsoft.com> wrote in message
news:1b8c01c3ff4d$64d17880$a601280a@.phx.gbl...
> Hi,
> I am getting error 1802, CREATE DATABASE failed. Some file
> names listed could not be created. Check previous errors.
>
> I have Windows 2000 professional installed on my PC.
> I am installing remedy 5.1 that uses MSSQL server 7 and I
> am getting the error above on remedy instalation...
> Any idea'
> Thanks
Showing posts with label file. Show all posts
Showing posts with label file. Show all posts
Friday, March 30, 2012
MS SQL Update Error
I have a database on a MSSQL Server 7 running on a Windows NT machine. This database works the last 4years with no problem. The database file is now 3 GB with 45 users. The last two months every single day an update error on a specific Table occurs. I cannot update a record in this table, and after this error occurs more than 100 records or more seemed to be locked. While I cannot edit the previous records I can create a new one with no problem. I have this problem once every sigle working day (ant the currious thing is that is occured from 8 to 10 in the morning every singke working day) . The table seems to work again after some hours or after one single day, or after I stop and start again the sql server service. Some times I have to wait some hours in order to manage to edit records in this table again. (I edit the records by using a program created with Microsoft Access and ODBC. When the error occurs I cannot edit the records neither by Access not by SQL Server Query Analyser).
This error doesn't occur when entering a new record, and might occur when only one user works with the specific Table. This table has 75 fields and about 70000 records. This table is the master of a table which has more than 200 fields and more than 750000 records. In the detail table I have no problems.
Similar problems not in this degree exist on a second database installation with about 25 users with the same table but running under a Windows 2000 Server machine.
Well when the problem appearead again I tried to edit the locked records by using Access ODBC, Access (adp project), Delphi with ADO-OLEDB and Delphi with native SQL drivers. The result was the same. A Timeout expired message appear. In the application log file of the MS SQLserver machine every time the the update error appears I get the following message: Could not Set Up Listen on Connection '1433'. Operating system Error 10049.
Any ideas??
Best regards,
Manolis PerrakisCan you supply the wording of the update error?
Also, since it tends to happen from 8-10 most mornings, you can check for blocking problems by running sp_who2 in Query Analyzer. If there are numbers in the "BlkBy" column, you have problems. Hopefully you will be able to figure out the blocker by the program- or host-name in the output of sp_who2.|||I don't have a solution for you. But I have experienced more than my share of timeouts and there's one thing I've learned: it's never what it says it is. But it seems to happen more the larger the number of elements there are in an index, and less on more normal databases. And we suspect it may be related to our use of EIDE drives instead of SCSI.
And I strongly suspect it has something to do with resources. For example: If you execute an update query causing SQL Server to execute a series of subqueries, and one of them hits a resource ceiling, one of the others with time out waiting for a thread to finish. The thread never finishes, because it's waiting for resources to be freed before it can continue. This happens all the time on our 1 GHZ server with 1GB of RAM.
I suggest you check all your indexes and make sure they're not clustered. Also, make sure you're not using too many connections if you can avoid it. And if you have too many tables that aren't normalized, try to fix that as well. Finally, you can do what I'm planning to do: change to MySql server or something else. IMNSHO, Sql Server isn't as robust as it could be.
I hope this helps.|||One other thing...Port 1433 is where SQL Server listens for connection requests. You're not opening the database everytime you do an update, are you?|||Thanks for the suggestions. My server is a Compaq ML350 with 3 SCSII hards disks and a Raid Controller, and about 600 MB RAM. I can see from the task manager that it uses all the resources. I might increase the RAM memory and in the next months I might get a new server.
Please tell me if there is a serious problem the fact that I also store in this server about 10000 photos with sizes about 2 GB, that are displayed as product pictures in the database program I've created.
I also have to mention that I use a lot of subqueries in the MSAccess program I use right now.
As far the connections issues, since I now use MSAccess for the clients, each table that is connected (attached) to the MSSQL Server holds internally its connection properies (datasource name, database name, username etc..), and since that I have about 200 tables attached from the SQL Server, this might create a connection problem.
I'm currently moving to Delphi 7, which has a global connection for all the tables of the same server. In this version the subqueries are replaced with optimised queries, and client datasets will be used in order to decrease the server load.
Best Regards,
Manolis Perrakis|||The data I store in image fields is usually quite a bit less than yours, but I don't think that's a problem. But I'm pretty sure the RAM is. You can improve things somewhat by making sure your logfile is on a different disk drive than the database, if you haven't done so already.
Try to get away from holding tables open where you can. Also, if you have a lot of indices on the master table, or a high number of values in the master index, I know from experience that can cause problems. Those problems can be alleviated by adding more RAM, further normalizing your database to reduce the number of keys (if that's possible), or looking at ways to reduce the amount of index storage--making sure you're not using clustered indexes, making sure that you're not using full-text indexing if you don't need it.
But I'm also wondering whether it's the bound controls that are the problem. At 8:00 is when everyone comes into work and launches the app, right? And by 10:00, app use drops down to a manageable level? Tables linked to app forms are almost always in Dynamic mode and I'm assuming that's the case here. If you were to modify your app so that the most common screens were read (releasing the recordset and holding the data in memory), and perform updates as that data was written (creating a new recordset for writing), you'd probably reduce the load on Sql Server significantly.
Not that any of this presents a panacea. I've spent the majority of my bugchasing over the past couple of years on problems with SQL Server/ADO. If I had any time at all, I would switch like a Tareyton smoker. :) But I think this problem can be solved.
This error doesn't occur when entering a new record, and might occur when only one user works with the specific Table. This table has 75 fields and about 70000 records. This table is the master of a table which has more than 200 fields and more than 750000 records. In the detail table I have no problems.
Similar problems not in this degree exist on a second database installation with about 25 users with the same table but running under a Windows 2000 Server machine.
Well when the problem appearead again I tried to edit the locked records by using Access ODBC, Access (adp project), Delphi with ADO-OLEDB and Delphi with native SQL drivers. The result was the same. A Timeout expired message appear. In the application log file of the MS SQLserver machine every time the the update error appears I get the following message: Could not Set Up Listen on Connection '1433'. Operating system Error 10049.
Any ideas??
Best regards,
Manolis PerrakisCan you supply the wording of the update error?
Also, since it tends to happen from 8-10 most mornings, you can check for blocking problems by running sp_who2 in Query Analyzer. If there are numbers in the "BlkBy" column, you have problems. Hopefully you will be able to figure out the blocker by the program- or host-name in the output of sp_who2.|||I don't have a solution for you. But I have experienced more than my share of timeouts and there's one thing I've learned: it's never what it says it is. But it seems to happen more the larger the number of elements there are in an index, and less on more normal databases. And we suspect it may be related to our use of EIDE drives instead of SCSI.
And I strongly suspect it has something to do with resources. For example: If you execute an update query causing SQL Server to execute a series of subqueries, and one of them hits a resource ceiling, one of the others with time out waiting for a thread to finish. The thread never finishes, because it's waiting for resources to be freed before it can continue. This happens all the time on our 1 GHZ server with 1GB of RAM.
I suggest you check all your indexes and make sure they're not clustered. Also, make sure you're not using too many connections if you can avoid it. And if you have too many tables that aren't normalized, try to fix that as well. Finally, you can do what I'm planning to do: change to MySql server or something else. IMNSHO, Sql Server isn't as robust as it could be.
I hope this helps.|||One other thing...Port 1433 is where SQL Server listens for connection requests. You're not opening the database everytime you do an update, are you?|||Thanks for the suggestions. My server is a Compaq ML350 with 3 SCSII hards disks and a Raid Controller, and about 600 MB RAM. I can see from the task manager that it uses all the resources. I might increase the RAM memory and in the next months I might get a new server.
Please tell me if there is a serious problem the fact that I also store in this server about 10000 photos with sizes about 2 GB, that are displayed as product pictures in the database program I've created.
I also have to mention that I use a lot of subqueries in the MSAccess program I use right now.
As far the connections issues, since I now use MSAccess for the clients, each table that is connected (attached) to the MSSQL Server holds internally its connection properies (datasource name, database name, username etc..), and since that I have about 200 tables attached from the SQL Server, this might create a connection problem.
I'm currently moving to Delphi 7, which has a global connection for all the tables of the same server. In this version the subqueries are replaced with optimised queries, and client datasets will be used in order to decrease the server load.
Best Regards,
Manolis Perrakis|||The data I store in image fields is usually quite a bit less than yours, but I don't think that's a problem. But I'm pretty sure the RAM is. You can improve things somewhat by making sure your logfile is on a different disk drive than the database, if you haven't done so already.
Try to get away from holding tables open where you can. Also, if you have a lot of indices on the master table, or a high number of values in the master index, I know from experience that can cause problems. Those problems can be alleviated by adding more RAM, further normalizing your database to reduce the number of keys (if that's possible), or looking at ways to reduce the amount of index storage--making sure you're not using clustered indexes, making sure that you're not using full-text indexing if you don't need it.
But I'm also wondering whether it's the bound controls that are the problem. At 8:00 is when everyone comes into work and launches the app, right? And by 10:00, app use drops down to a manageable level? Tables linked to app forms are almost always in Dynamic mode and I'm assuming that's the case here. If you were to modify your app so that the most common screens were read (releasing the recordset and holding the data in memory), and perform updates as that data was written (creating a new recordset for writing), you'd probably reduce the load on Sql Server significantly.
Not that any of this presents a panacea. I've spent the majority of my bugchasing over the past couple of years on problems with SQL Server/ADO. If I had any time at all, I would switch like a Tareyton smoker. :) But I think this problem can be solved.
MS SQL Update Error
I have a database on a MSSQL Server 7 running on a Windows NT machine. This database works the last 4years with no problem. The database file is now 3 GB. The last two months every single day an update error on a specific Table occurs. I cannot update a record in this table, and after this error occurs more than 100 records or more seemed to be locked. While I cannot edit the previous records I can create a new one with no problem. I have this problem once every sigle working day (ant the currious thing is that is occured from 8 to 10 in the morning every singke working day) . The table seems to work again after some hours or after one single day, or after I stop and start again the sql server service. Some times I have to wait some hours in order to manage to edit records in this table again. (I edit the records by using a program created with Microsoft Access and ODBC. When the error occurs I cannot edit the records neither by Access not by SQL Server Query Analyser).
This error doesn't occur when entering a new record, and might occur when only one user works with the specific Table. This table has 75 fields and about 70000 records.
Similar problems not in this degree exist on a second database installation with about 25 users with the same table but running under a Windows 2000 Server machine.
Any ideas??
Best Regards,
Manolis Perrakis
manolo_perrakis@.mail.grDoes the error occur when you try to edit the records using ONLY query analyzer?
Are you using an MS Access mdb file to edit the data, or are you using a Microsoft Access Data Project (ADP) file?
blindman|||Does the error occur when you try to edit the records using ONLY query analyzer?
Are you using an MS Access mdb file to edit the data, or are you using a Microsoft Access Data Project (ADP) file?
The error occurs both with Access (I'm using an mdb file connected with ODBC with SQL Server) and with the Query Analyser. When this error occurs I cannot edit this table from any computer in the network.
Therefore I'm trying to edit the table using ODBC. I haven't tried by using an ADP project, or by using another program like Delphi which uses another connection method like OLE DB.|||when you get to the point when "this" error occurrs again, can you switch to query analyzer and write an update query for a specific record?
after you get "that" error in query analyzer, paste it here. i suspect you can also get this error from sql server errorlog by double-clicking on the entry with the error. i suspect the error you're getting is referencing the total record length. if this is the case you'll need to either shrink a couple of fields or split the table into two to allow for all your fields to be updateable. to do that seemlessly for the front-end you'll have to write a view and reference this view in your inserts, updates, deletes, and selects.
This error doesn't occur when entering a new record, and might occur when only one user works with the specific Table. This table has 75 fields and about 70000 records.
Similar problems not in this degree exist on a second database installation with about 25 users with the same table but running under a Windows 2000 Server machine.
Any ideas??
Best Regards,
Manolis Perrakis
manolo_perrakis@.mail.grDoes the error occur when you try to edit the records using ONLY query analyzer?
Are you using an MS Access mdb file to edit the data, or are you using a Microsoft Access Data Project (ADP) file?
blindman|||Does the error occur when you try to edit the records using ONLY query analyzer?
Are you using an MS Access mdb file to edit the data, or are you using a Microsoft Access Data Project (ADP) file?
The error occurs both with Access (I'm using an mdb file connected with ODBC with SQL Server) and with the Query Analyser. When this error occurs I cannot edit this table from any computer in the network.
Therefore I'm trying to edit the table using ODBC. I haven't tried by using an ADP project, or by using another program like Delphi which uses another connection method like OLE DB.|||when you get to the point when "this" error occurrs again, can you switch to query analyzer and write an update query for a specific record?
after you get "that" error in query analyzer, paste it here. i suspect you can also get this error from sql server errorlog by double-clicking on the entry with the error. i suspect the error you're getting is referencing the total record length. if this is the case you'll need to either shrink a couple of fields or split the table into two to allow for all your fields to be updateable. to do that seemlessly for the front-end you'll have to write a view and reference this view in your inserts, updates, deletes, and selects.
MS SQL Srv 2000 and extended stored procedures
hi,
I have created my own dll file that I would like to use in sql 2000 as an
extended stored procedure. I have checked the dll is written correctly (I ca
n
use it in other application). The dll file is created in C# (Visual Studio
2005).
Unfortunatelly I cannot use it in sql as the extended procedure. I am
getting error: Cannot find the function <<f_name>> in the library
<<path\library.dll>>. Reason: 127(error not found).Extended procedures need to be written in C or C++ (or Delphi, so I've heard
). A language that can
create classic DLL files, not any of the modern fancy COM dlls. Also, SQL Se
rver 2000 doesn't
support hosting any type of CLR code, whether through xp or sp_OACreate, or
whether with or without
any wrappers.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:17231DDF-B357-4227-94E1-D94C57AB54CC@.microsoft.com...
> hi,
> I have created my own dll file that I would like to use in sql 2000 as an
> extended stored procedure. I have checked the dll is written correctly (I
can
> use it in other application). The dll file is created in C# (Visual Studio
> 2005).
> Unfortunatelly I cannot use it in sql as the extended procedure. I am
> getting error: Cannot find the function <<f_name>> in the library
> <<path\library.dll>>. Reason: 127(error not found).|||Hi
This may be of interest:
"Using extended stored procedures or SP_OA stored procedures to load CLR in
SQL Server is not supported"
http://support.microsoft.com/default.aspx?scid=322884
Regards
--
Mike
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uBcPMTWwGHA.3264@.TK2MSFTNGP03.phx.gbl...
> Extended procedures need to be written in C or C++ (or Delphi, so I've
> heard). A language that can create classic DLL files, not any of the
> modern fancy COM dlls. Also, SQL Server 2000 doesn't support hosting any
> type of CLR code, whether through xp or sp_OACreate, or whether with or
> without any wrappers.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:17231DDF-B357-4227-94E1-D94C57AB54CC@.microsoft.com...
>|||so is it possible to create an extended stored procedure in Visual Studio
2005 (C++)?
"Michael Epprecht [MSFT]" wrote:
> Hi
> This may be of interest:
> "Using extended stored procedures or SP_OA stored procedures to load CLR i
n
> SQL Server is not supported"
> http://support.microsoft.com/default.aspx?scid=322884
> Regards
> --
> Mike
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:uBcPMTWwGHA.3264@.TK2MSFTNGP03.phx.gbl...
>
>|||"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:8F880F51-DD0E-4FC9-8887-88A805920AC9@.microsoft.com...
> so is it possible to create an extended stored procedure in Visual Studio
> 2005 (C++)?
>
Yes, but it's much easier and safer to use SQL 2005 where you can use your
C# code inside the database.
David|||Can you show me how to do that? plz
"David Browne" wrote:
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:8F880F51-DD0E-4FC9-8887-88A805920AC9@.microsoft.com...
> Yes, but it's much easier and safer to use SQL 2005 where you can use your
> C# code inside the database.
> David
>
>|||"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:884D5F80-4D8F-4252-824A-2B2438330B76@.microsoft.com...
> Can you show me how to do that? plz
>
Programming SQL Server 2005 Using the .NET Framework
http://msdn.microsoft.com/sql/learn...lr/default.aspx
David
I have created my own dll file that I would like to use in sql 2000 as an
extended stored procedure. I have checked the dll is written correctly (I ca
n
use it in other application). The dll file is created in C# (Visual Studio
2005).
Unfortunatelly I cannot use it in sql as the extended procedure. I am
getting error: Cannot find the function <<f_name>> in the library
<<path\library.dll>>. Reason: 127(error not found).Extended procedures need to be written in C or C++ (or Delphi, so I've heard
). A language that can
create classic DLL files, not any of the modern fancy COM dlls. Also, SQL Se
rver 2000 doesn't
support hosting any type of CLR code, whether through xp or sp_OACreate, or
whether with or without
any wrappers.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:17231DDF-B357-4227-94E1-D94C57AB54CC@.microsoft.com...
> hi,
> I have created my own dll file that I would like to use in sql 2000 as an
> extended stored procedure. I have checked the dll is written correctly (I
can
> use it in other application). The dll file is created in C# (Visual Studio
> 2005).
> Unfortunatelly I cannot use it in sql as the extended procedure. I am
> getting error: Cannot find the function <<f_name>> in the library
> <<path\library.dll>>. Reason: 127(error not found).|||Hi
This may be of interest:
"Using extended stored procedures or SP_OA stored procedures to load CLR in
SQL Server is not supported"
http://support.microsoft.com/default.aspx?scid=322884
Regards
--
Mike
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uBcPMTWwGHA.3264@.TK2MSFTNGP03.phx.gbl...
> Extended procedures need to be written in C or C++ (or Delphi, so I've
> heard). A language that can create classic DLL files, not any of the
> modern fancy COM dlls. Also, SQL Server 2000 doesn't support hosting any
> type of CLR code, whether through xp or sp_OACreate, or whether with or
> without any wrappers.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:17231DDF-B357-4227-94E1-D94C57AB54CC@.microsoft.com...
>|||so is it possible to create an extended stored procedure in Visual Studio
2005 (C++)?
"Michael Epprecht [MSFT]" wrote:
> Hi
> This may be of interest:
> "Using extended stored procedures or SP_OA stored procedures to load CLR i
n
> SQL Server is not supported"
> http://support.microsoft.com/default.aspx?scid=322884
> Regards
> --
> Mike
> This posting is provided "AS IS" with no warranties, and confers no rights
.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:uBcPMTWwGHA.3264@.TK2MSFTNGP03.phx.gbl...
>
>|||"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:8F880F51-DD0E-4FC9-8887-88A805920AC9@.microsoft.com...
> so is it possible to create an extended stored procedure in Visual Studio
> 2005 (C++)?
>
Yes, but it's much easier and safer to use SQL 2005 where you can use your
C# code inside the database.
David|||Can you show me how to do that? plz
"David Browne" wrote:
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:8F880F51-DD0E-4FC9-8887-88A805920AC9@.microsoft.com...
> Yes, but it's much easier and safer to use SQL 2005 where you can use your
> C# code inside the database.
> David
>
>|||"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:884D5F80-4D8F-4252-824A-2B2438330B76@.microsoft.com...
> Can you show me how to do that? plz
>
Programming SQL Server 2005 Using the .NET Framework
http://msdn.microsoft.com/sql/learn...lr/default.aspx
David
MS SQL Srv 2000 and extended stored procedures
hi,
I have created my own dll file that I would like to use in sql 2000 as an
extended stored procedure. I have checked the dll is written correctly (I can
use it in other application). The dll file is created in C# (Visual Studio
2005).
Unfortunatelly I cannot use it in sql as the extended procedure. I am
getting error: Cannot find the function <<f_name>> in the library
<<path\library.dll>>. Reason: 127(error not found).Extended procedures need to be written in C or C++ (or Delphi, so I've heard). A language that can
create classic DLL files, not any of the modern fancy COM dlls. Also, SQL Server 2000 doesn't
support hosting any type of CLR code, whether through xp or sp_OACreate, or whether with or without
any wrappers.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:17231DDF-B357-4227-94E1-D94C57AB54CC@.microsoft.com...
> hi,
> I have created my own dll file that I would like to use in sql 2000 as an
> extended stored procedure. I have checked the dll is written correctly (I can
> use it in other application). The dll file is created in C# (Visual Studio
> 2005).
> Unfortunatelly I cannot use it in sql as the extended procedure. I am
> getting error: Cannot find the function <<f_name>> in the library
> <<path\library.dll>>. Reason: 127(error not found).|||Hi
This may be of interest:
"Using extended stored procedures or SP_OA stored procedures to load CLR in
SQL Server is not supported"
http://support.microsoft.com/default.aspx?scid=322884
Regards
--
Mike
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uBcPMTWwGHA.3264@.TK2MSFTNGP03.phx.gbl...
> Extended procedures need to be written in C or C++ (or Delphi, so I've
> heard). A language that can create classic DLL files, not any of the
> modern fancy COM dlls. Also, SQL Server 2000 doesn't support hosting any
> type of CLR code, whether through xp or sp_OACreate, or whether with or
> without any wrappers.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:17231DDF-B357-4227-94E1-D94C57AB54CC@.microsoft.com...
>> hi,
>> I have created my own dll file that I would like to use in sql 2000 as an
>> extended stored procedure. I have checked the dll is written correctly (I
>> can
>> use it in other application). The dll file is created in C# (Visual
>> Studio
>> 2005).
>> Unfortunatelly I cannot use it in sql as the extended procedure. I am
>> getting error: Cannot find the function <<f_name>> in the library
>> <<path\library.dll>>. Reason: 127(error not found).
>|||so is it possible to create an extended stored procedure in Visual Studio
2005 (C++)?
"Michael Epprecht [MSFT]" wrote:
> Hi
> This may be of interest:
> "Using extended stored procedures or SP_OA stored procedures to load CLR in
> SQL Server is not supported"
> http://support.microsoft.com/default.aspx?scid=322884
> Regards
> --
> Mike
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:uBcPMTWwGHA.3264@.TK2MSFTNGP03.phx.gbl...
> > Extended procedures need to be written in C or C++ (or Delphi, so I've
> > heard). A language that can create classic DLL files, not any of the
> > modern fancy COM dlls. Also, SQL Server 2000 doesn't support hosting any
> > type of CLR code, whether through xp or sp_OACreate, or whether with or
> > without any wrappers.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "Chris" <Chris@.discussions.microsoft.com> wrote in message
> > news:17231DDF-B357-4227-94E1-D94C57AB54CC@.microsoft.com...
> >> hi,
> >> I have created my own dll file that I would like to use in sql 2000 as an
> >> extended stored procedure. I have checked the dll is written correctly (I
> >> can
> >> use it in other application). The dll file is created in C# (Visual
> >> Studio
> >> 2005).
> >> Unfortunatelly I cannot use it in sql as the extended procedure. I am
> >> getting error: Cannot find the function <<f_name>> in the library
> >> <<path\library.dll>>. Reason: 127(error not found).
> >
>
>|||"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:8F880F51-DD0E-4FC9-8887-88A805920AC9@.microsoft.com...
> so is it possible to create an extended stored procedure in Visual Studio
> 2005 (C++)?
>
Yes, but it's much easier and safer to use SQL 2005 where you can use your
C# code inside the database.
David|||Can you show me how to do that? plz
"David Browne" wrote:
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:8F880F51-DD0E-4FC9-8887-88A805920AC9@.microsoft.com...
> > so is it possible to create an extended stored procedure in Visual Studio
> > 2005 (C++)?
> >
> Yes, but it's much easier and safer to use SQL 2005 where you can use your
> C# code inside the database.
> David
>
>|||"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:884D5F80-4D8F-4252-824A-2B2438330B76@.microsoft.com...
> Can you show me how to do that? plz
>
Programming SQL Server 2005 Using the .NET Framework
http://msdn.microsoft.com/sql/learning/prog/clr/default.aspx
David
I have created my own dll file that I would like to use in sql 2000 as an
extended stored procedure. I have checked the dll is written correctly (I can
use it in other application). The dll file is created in C# (Visual Studio
2005).
Unfortunatelly I cannot use it in sql as the extended procedure. I am
getting error: Cannot find the function <<f_name>> in the library
<<path\library.dll>>. Reason: 127(error not found).Extended procedures need to be written in C or C++ (or Delphi, so I've heard). A language that can
create classic DLL files, not any of the modern fancy COM dlls. Also, SQL Server 2000 doesn't
support hosting any type of CLR code, whether through xp or sp_OACreate, or whether with or without
any wrappers.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:17231DDF-B357-4227-94E1-D94C57AB54CC@.microsoft.com...
> hi,
> I have created my own dll file that I would like to use in sql 2000 as an
> extended stored procedure. I have checked the dll is written correctly (I can
> use it in other application). The dll file is created in C# (Visual Studio
> 2005).
> Unfortunatelly I cannot use it in sql as the extended procedure. I am
> getting error: Cannot find the function <<f_name>> in the library
> <<path\library.dll>>. Reason: 127(error not found).|||Hi
This may be of interest:
"Using extended stored procedures or SP_OA stored procedures to load CLR in
SQL Server is not supported"
http://support.microsoft.com/default.aspx?scid=322884
Regards
--
Mike
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uBcPMTWwGHA.3264@.TK2MSFTNGP03.phx.gbl...
> Extended procedures need to be written in C or C++ (or Delphi, so I've
> heard). A language that can create classic DLL files, not any of the
> modern fancy COM dlls. Also, SQL Server 2000 doesn't support hosting any
> type of CLR code, whether through xp or sp_OACreate, or whether with or
> without any wrappers.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:17231DDF-B357-4227-94E1-D94C57AB54CC@.microsoft.com...
>> hi,
>> I have created my own dll file that I would like to use in sql 2000 as an
>> extended stored procedure. I have checked the dll is written correctly (I
>> can
>> use it in other application). The dll file is created in C# (Visual
>> Studio
>> 2005).
>> Unfortunatelly I cannot use it in sql as the extended procedure. I am
>> getting error: Cannot find the function <<f_name>> in the library
>> <<path\library.dll>>. Reason: 127(error not found).
>|||so is it possible to create an extended stored procedure in Visual Studio
2005 (C++)?
"Michael Epprecht [MSFT]" wrote:
> Hi
> This may be of interest:
> "Using extended stored procedures or SP_OA stored procedures to load CLR in
> SQL Server is not supported"
> http://support.microsoft.com/default.aspx?scid=322884
> Regards
> --
> Mike
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:uBcPMTWwGHA.3264@.TK2MSFTNGP03.phx.gbl...
> > Extended procedures need to be written in C or C++ (or Delphi, so I've
> > heard). A language that can create classic DLL files, not any of the
> > modern fancy COM dlls. Also, SQL Server 2000 doesn't support hosting any
> > type of CLR code, whether through xp or sp_OACreate, or whether with or
> > without any wrappers.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "Chris" <Chris@.discussions.microsoft.com> wrote in message
> > news:17231DDF-B357-4227-94E1-D94C57AB54CC@.microsoft.com...
> >> hi,
> >> I have created my own dll file that I would like to use in sql 2000 as an
> >> extended stored procedure. I have checked the dll is written correctly (I
> >> can
> >> use it in other application). The dll file is created in C# (Visual
> >> Studio
> >> 2005).
> >> Unfortunatelly I cannot use it in sql as the extended procedure. I am
> >> getting error: Cannot find the function <<f_name>> in the library
> >> <<path\library.dll>>. Reason: 127(error not found).
> >
>
>|||"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:8F880F51-DD0E-4FC9-8887-88A805920AC9@.microsoft.com...
> so is it possible to create an extended stored procedure in Visual Studio
> 2005 (C++)?
>
Yes, but it's much easier and safer to use SQL 2005 where you can use your
C# code inside the database.
David|||Can you show me how to do that? plz
"David Browne" wrote:
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:8F880F51-DD0E-4FC9-8887-88A805920AC9@.microsoft.com...
> > so is it possible to create an extended stored procedure in Visual Studio
> > 2005 (C++)?
> >
> Yes, but it's much easier and safer to use SQL 2005 where you can use your
> C# code inside the database.
> David
>
>|||"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:884D5F80-4D8F-4252-824A-2B2438330B76@.microsoft.com...
> Can you show me how to do that? plz
>
Programming SQL Server 2005 Using the .NET Framework
http://msdn.microsoft.com/sql/learning/prog/clr/default.aspx
David
Wednesday, March 28, 2012
MS SQl server2000 Restoration
when I restored backup file from system to another system
gave me the message "An internal consistency error
occurred.Contact Technical Support for assistance.Restore
Database is Terminating abnormally"
Abdelzahir abdelmaboud
Sudatel Co.
DBA
abdzahir@.hotmail.comAbdelzahir,
Perhaps the database was corrupt before you backed it up? Can you run
DBCC CHECKDB on the source database, and back it up again? Are you using
SQL Server native backup commands to do this or an external component
such as Litespeed? Very occasionally, external components can corrupt a
backup file.
It sounds like the database was corrupt before you backed it up, and
then it can't restore it.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Abdelzahir Abdelmaboud wrote:
> when I restored backup file from system to another system
> gave me the message "An internal consistency error
> occurred.Contact Technical Support for assistance.Restore
> Database is Terminating abnormally"
> Abdelzahir abdelmaboud
> Sudatel Co.
> DBA
> abdzahir@.hotmail.comsql
gave me the message "An internal consistency error
occurred.Contact Technical Support for assistance.Restore
Database is Terminating abnormally"
Abdelzahir abdelmaboud
Sudatel Co.
DBA
abdzahir@.hotmail.comAbdelzahir,
Perhaps the database was corrupt before you backed it up? Can you run
DBCC CHECKDB on the source database, and back it up again? Are you using
SQL Server native backup commands to do this or an external component
such as Litespeed? Very occasionally, external components can corrupt a
backup file.
It sounds like the database was corrupt before you backed it up, and
then it can't restore it.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Abdelzahir Abdelmaboud wrote:
> when I restored backup file from system to another system
> gave me the message "An internal consistency error
> occurred.Contact Technical Support for assistance.Restore
> Database is Terminating abnormally"
> Abdelzahir abdelmaboud
> Sudatel Co.
> DBA
> abdzahir@.hotmail.comsql
MS SQl server2000 Restoration
when I restored backup file from system to another system
gave me the message "An internal consistency error
occurred.Contact Technical Support for assistance.Restore
Database is Terminating abnormally"
Abdelzahir abdelmaboud
Sudatel Co.
DBA
abdzahir@.hotmail.com
Abdelzahir,
Perhaps the database was corrupt before you backed it up? Can you run
DBCC CHECKDB on the source database, and back it up again? Are you using
SQL Server native backup commands to do this or an external component
such as Litespeed? Very occasionally, external components can corrupt a
backup file.
It sounds like the database was corrupt before you backed it up, and
then it can't restore it.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Abdelzahir Abdelmaboud wrote:
> when I restored backup file from system to another system
> gave me the message "An internal consistency error
> occurred.Contact Technical Support for assistance.Restore
> Database is Terminating abnormally"
> Abdelzahir abdelmaboud
> Sudatel Co.
> DBA
> abdzahir@.hotmail.com
gave me the message "An internal consistency error
occurred.Contact Technical Support for assistance.Restore
Database is Terminating abnormally"
Abdelzahir abdelmaboud
Sudatel Co.
DBA
abdzahir@.hotmail.com
Abdelzahir,
Perhaps the database was corrupt before you backed it up? Can you run
DBCC CHECKDB on the source database, and back it up again? Are you using
SQL Server native backup commands to do this or an external component
such as Litespeed? Very occasionally, external components can corrupt a
backup file.
It sounds like the database was corrupt before you backed it up, and
then it can't restore it.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Abdelzahir Abdelmaboud wrote:
> when I restored backup file from system to another system
> gave me the message "An internal consistency error
> occurred.Contact Technical Support for assistance.Restore
> Database is Terminating abnormally"
> Abdelzahir abdelmaboud
> Sudatel Co.
> DBA
> abdzahir@.hotmail.com
MS sql server query file
Hi All.
Have a nice day.
I have one file and all tables and fields created in this file, this file name is "db1.sql", i downloaded this file from a internet demo. and programmer give this file to use in the asp.net code. but i cannot open this file.
I want to use this file in my sqlepress, how can i import or bring to my sqlexpress server and use it ?
Please can you help me how can i use it?
Thanks.
Zahyea.
The file you download is a script file that contains the database and table creation, insertion of data, and views and procedures if any.
You need to execute the sql script. You can download SQL Server Management Studio for SQL Express that allows you to execute scripts against a SQL instance/database.
Friday, March 23, 2012
MS SQL Server 2005 -- Cant not attach to AdventureWorks Database
I have MS SQL Server 2005 installed and when trying to connect to AdventureWorks DB
Downloaded AdventureWorksDB.msi file and when trying to attach recieve this error when running script ?
Msg 1813, Level 16, State 2, Line 1
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
Msg 602, Level 21, State 50, Line 1
Could not find row in sysindexes for database ID 8, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
Then tried to attach the DB and get this
TITLE: Microsoft SQL Server Management Studio
Attach database failed for Server 'JKIMBLE1'. (Microsoft.SqlServer.Smo)
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Could not find row in sysindexes for database ID 8, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=602&LinkId=20476
BUTTONS:
OK
Is there a difference between MS SQL Server 2005 and SQL Server 2005 Express Edition
I am having the same problem. I've done some research, trying to fix this.This thing is just curious because a coworker successfully installed the AdventureWorks DB and our computers are almost identical, HW and SW.
Anyone?
|||
Are you a server admin on the box where you are trying to attach the database? Or a local admin on the box?
There is no difference in the file format between the various editions of SQL Server 2005. This sounds like a rights problem to me.
|||Fortunately I solved my problem. The thing with me was that I had MSSQL Server 2000 installed on my machine. And when I opened the SQL Server Management Studio I used to connect to the instance of 2000 and not 2005. (e.g. LOCALHOST, instead of LOCALHOST\SQLEXPRESS)Such a stupid thing, but I never read about it anywhere else.
I guess my problem was that there's no compatibility from 2005 to 2000.
Hope this works for you as well JKimble.
|||Thanks for the info...!! I had exact same issue - I downloaded AdventureWorks database and got the same error when I tried to attach to LOCALHOST but it worked Ok when I changed to LOCALHOST\SQLEXPRESS... NB: the same occurs for AdventureWorksDW database...|||
SteveSatriani wrote:
Thanks for the info...!! I had exact same issue - I downloaded AdventureWorks database and got the same error when I tried to attach to LOCALHOST but it worked Ok when I changed to LOCALHOST\SQLEXPRESS... NB: the same occurs for AdventureWorksDW database...
Two things AdventureWorksDW DB will not work with Express because there is no BI management studio and I know it was not created to work with 2000. But the OLTP AdventureWorks DB comes in both 2000 and 2005. Hope this helps.
MS SQL Server 2005 -- Cant not attach to AdventureWorks Database
I have MS SQL Server 2005 installed and when trying to connect to AdventureWorks DB
Downloaded AdventureWorksDB.msi file and when trying to attach recieve this error when running script ?
Msg 1813, Level 16, State 2, Line 1
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.
Msg 602, Level 21, State 50, Line 1
Could not find row in sysindexes for database ID 8, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
Then tried to attach the DB and get this
TITLE: Microsoft SQL Server Management Studio
Attach database failed for Server 'JKIMBLE1'. (Microsoft.SqlServer.Smo)
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Could not find row in sysindexes for database ID 8, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=602&LinkId=20476
BUTTONS:
OK
Is there a difference between MS SQL Server 2005 and SQL Server 2005 Express Edition
I am having the same problem. I've done some research, trying to fix this.This thing is just curious because a coworker successfully installed the AdventureWorks DB and our computers are almost identical, HW and SW.
Anyone?
|||
Are you a server admin on the box where you are trying to attach the database? Or a local admin on the box?
There is no difference in the file format between the various editions of SQL Server 2005. This sounds like a rights problem to me.
|||Fortunately I solved my problem. The thing with me was that I had MSSQL Server 2000 installed on my machine. And when I opened the SQL Server Management Studio I used to connect to the instance of 2000 and not 2005. (e.g. LOCALHOST, instead of LOCALHOST\SQLEXPRESS)Such a stupid thing, but I never read about it anywhere else.
I guess my problem was that there's no compatibility from 2005 to 2000.
Hope this works for you as well JKimble.
|||Thanks for the info...!! I had exact same issue - I downloaded AdventureWorks database and got the same error when I tried to attach to LOCALHOST but it worked Ok when I changed to LOCALHOST\SQLEXPRESS... NB: the same occurs for AdventureWorksDW database...|||
Thanks for the info...!! I had exact same issue - I downloaded AdventureWorks database and got the same error when I tried to attach to LOCALHOST but it worked Ok when I changed to LOCALHOST\SQLEXPRESS... NB: the same occurs for AdventureWorksDW database...
Two things AdventureWorksDW DB will not work with Express because there is no BI management studio and I know it was not created to work with 2000. But the OLTP AdventureWorks DB comes in both 2000 and 2005. Hope this helps.
Monday, March 19, 2012
MS SQL Server
Hi Support,
I am unable to start the MS SQL Server.
Encountered error msg: "The system cannot find the file specified"
Please advise.
Thanks & Regards.
Vic..Hi John,
SQL Server version is 8.0
Where can I get the SQL logfile ?
Thanks & regards
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> What version of SQL Server are you using? You should be able to find more
> information in the SQL Server log file. If you a want to start SQL Server
for
> a command prompt see [url]http://msdn2.microsoft.com/en-us/library/ms180965.aspx[/url
]
> John
> "Vic" wrote:
>|||Hi Vic
The SQL Server Event/Error Log File can be found in the <install
dir>\MSSQL\LOG directory and is called ERRORLOG older ones will have
ascending numeric prefixes.
John
"Vic" wrote:
[vbcol=seagreen]
> Hi John,
> SQL Server version is 8.0
> Where can I get the SQL logfile ?
> Thanks & regards
> "John Bell" wrote:
>|||Hi John,
My MSSQL Server is shown "Not Connected"
Errorlog msg "SQL terminated bcos of system shutdown"
Pls advise again. Thanks.
"John Bell" wrote:
[vbcol=seagreen]
> Hi Vic
> The SQL Server Event/Error Log File can be found in the <install
> dir>\MSSQL\LOG directory and is called ERRORLOG older ones will have
> ascending numeric prefixes.
> John
> "Vic" wrote:
>
I am unable to start the MS SQL Server.
Encountered error msg: "The system cannot find the file specified"
Please advise.
Thanks & Regards.
Vic..Hi John,
SQL Server version is 8.0
Where can I get the SQL logfile ?
Thanks & regards
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> What version of SQL Server are you using? You should be able to find more
> information in the SQL Server log file. If you a want to start SQL Server
for
> a command prompt see [url]http://msdn2.microsoft.com/en-us/library/ms180965.aspx[/url
]
> John
> "Vic" wrote:
>|||Hi Vic
The SQL Server Event/Error Log File can be found in the <install
dir>\MSSQL\LOG directory and is called ERRORLOG older ones will have
ascending numeric prefixes.
John
"Vic" wrote:
[vbcol=seagreen]
> Hi John,
> SQL Server version is 8.0
> Where can I get the SQL logfile ?
> Thanks & regards
> "John Bell" wrote:
>|||Hi John,
My MSSQL Server is shown "Not Connected"
Errorlog msg "SQL terminated bcos of system shutdown"
Pls advise again. Thanks.
"John Bell" wrote:
[vbcol=seagreen]
> Hi Vic
> The SQL Server Event/Error Log File can be found in the <install
> dir>\MSSQL\LOG directory and is called ERRORLOG older ones will have
> ascending numeric prefixes.
> John
> "Vic" wrote:
>
MS SQL Server
Hi Support,
I am unable to start the MS SQL Server.
Encountered error msg: "The system cannot find the file specified"
Please advise.
Thanks & Regards.
Vic..
Hi John,
SQL Server version is 8.0
Where can I get the SQL logfile ?
Thanks & regards
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> What version of SQL Server are you using? You should be able to find more
> information in the SQL Server log file. If you a want to start SQL Server for
> a command prompt see http://msdn2.microsoft.com/en-us/library/ms180965.aspx
> John
> "Vic" wrote:
|||Hi Vic
The SQL Server Event/Error Log File can be found in the <install
dir>\MSSQL\LOG directory and is called ERRORLOG older ones will have
ascending numeric prefixes.
John
"Vic" wrote:
[vbcol=seagreen]
> Hi John,
> SQL Server version is 8.0
> Where can I get the SQL logfile ?
> Thanks & regards
> "John Bell" wrote:
|||Hi John,
My MSSQL Server is shown "Not Connected"
Errorlog msg "SQL terminated bcos of system shutdown"
Pls advise again. Thanks.
"John Bell" wrote:
[vbcol=seagreen]
> Hi Vic
> The SQL Server Event/Error Log File can be found in the <install
> dir>\MSSQL\LOG directory and is called ERRORLOG older ones will have
> ascending numeric prefixes.
> John
> "Vic" wrote:
I am unable to start the MS SQL Server.
Encountered error msg: "The system cannot find the file specified"
Please advise.
Thanks & Regards.
Vic..
Hi John,
SQL Server version is 8.0
Where can I get the SQL logfile ?
Thanks & regards
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> What version of SQL Server are you using? You should be able to find more
> information in the SQL Server log file. If you a want to start SQL Server for
> a command prompt see http://msdn2.microsoft.com/en-us/library/ms180965.aspx
> John
> "Vic" wrote:
|||Hi Vic
The SQL Server Event/Error Log File can be found in the <install
dir>\MSSQL\LOG directory and is called ERRORLOG older ones will have
ascending numeric prefixes.
John
"Vic" wrote:
[vbcol=seagreen]
> Hi John,
> SQL Server version is 8.0
> Where can I get the SQL logfile ?
> Thanks & regards
> "John Bell" wrote:
|||Hi John,
My MSSQL Server is shown "Not Connected"
Errorlog msg "SQL terminated bcos of system shutdown"
Pls advise again. Thanks.
"John Bell" wrote:
[vbcol=seagreen]
> Hi Vic
> The SQL Server Event/Error Log File can be found in the <install
> dir>\MSSQL\LOG directory and is called ERRORLOG older ones will have
> ascending numeric prefixes.
> John
> "Vic" wrote:
Monday, March 12, 2012
ms sql mdf database file attached vs created on sql server
Hi all
I have a question concerning sql database mdf files. In the old days I would user a ms access database. This file would be stored with the actual web files and would utilise a dsn connection.
I have noted when designing with vwd 2005 express it allows you to use 2 methods of creating a mdf database. You can either create it as an attachment mdf or you can create it directly using sql manager.
My question is, if you create the mdf database as an attachement file can you store it in the same manner as if you where using a ms access database, meaning can you store it with the web site's files so it uses the file storage allocated size and then create a connection similar to a dsn (but for sql) to the isp's sql engine or does it have to be uploaded to the isp' s sql server.
The reason for this question is some of my customers do not want to pay the extra cost to have an sql allocation, however I do not want to go back to using old asp methods to create advanced sites as I prefer using stored procedures.
Any help will be appreciated
Hi,
you can attach your .mdf file (SQL Server Express) to a database (Attaching a .mdf file when you don't have the .ldf file available). However I think the hosting company will charge your customers for attaching it. To my knowledge you don't have a replacement available like DSN.
Grz, Kris.
|||Hi there,
My first website I did using Visual Studio I used an sql express database. Most hosting companys only use SQL server so you'll have to do some changes to your express database to get it hosted. So it doesnt really matter which way you design your database.
The hosting company will usually place your database on a separate secure server where you'll be able to access through SQL Server Manager once you have a static IP address. I'm not sure which hosting company you use but I live in Ireland and the best company here for windows hosting iswww.blacknight.ie
I use the standard windows hosting which allows you have up to 16 websites and 16 SQL server databases. An excellent company.
I recommend if you are going to use this a lot, upgrade your package to Visual Studio pro and this includes SQL Server Developer edition which allows you to create a SQL Server 2005 database which makes it easier when you go to publish your application.
Hope this is some use to you.
Anthony
|||Hi Kris
So what you are saying is you can attach a database to an sql server without having to import it directly. Which means the database can run externally from the sql server. My hosting company I think offers it for free if you are attaching and they have a control panel which makes it user friendly to do this by yourself. I will contact them again to verify. www.sahost.co.za
|||
Hi,
about 1,5 years ago I tried out a free hosting for ASP.NET 2.0 where you could upload a .mdf file to and in their admin pages they provided such an attach procedure. Unfortunately I don't remember their name.
Grz, Kris.
MS SQL Error 823 I/O Error
Hi there,
I am reinstall my OS (Win2k Server) and try to attach back my database to SQL Server (MS SQL 2000).
After selecting MDF and LDF file. It come out with all those message below in my event viwer. And attach database action is fail.
I had check with Microsoft and download the latest Server Pack 3, but still nothing is change. I am panic here.
Can any one help me to solve this problem.
Your help is very much appreciated.
Thank you.
Dave
Message copy from Event Viwer.
17052 :
Device activation error. The physical file name 'C:\Program Files\Microsoft SQL Server\MSSQL\data\ultra_Log.LDF' may be incorrect.
Error: 823, Severity: 24, State: 6
I/O error (torn page) detected during read at offset 0000000000000000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\ultra_Log.LDF'.
17207 :
udopen: Operating system error 5(error not found) during the creation/opening of physical device C:\Program Files\Microsoft SQL Server\MSSQL\data\ultra_Data.MDF.
17204 :
FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL Server\MSSQL\data\ultra_Data.MDF for virtual device number (VDN) 1.
17052 :
Device activation error. The physical file name 'C:\Program Files\Microsoft SQL Server\MSSQL\data\ultra_Data.MDF' may be incorrect.Judging from the error messages, are you certain you have the files in the correct path? Just trying to eliminate the obvious, here.|||Originally posted by MCrowley
Judging from the error messages, are you certain you have the files in the correct path? Just trying to eliminate the obvious, here.
Well....i just copy back the file to C:\Program Files\Microsoft SQL Server\MSSQL\Data
so....i just using the utility in the Enterprise Manager call Attach Database...is something like sp_attach_db but in windows graphic mode...
even i am using sp_attach_db command in command prompt, same mssg will appear...
here by i submit my database file...the log file and the data file...
please help to solve it...
i have no idea about all this...
thank you so much
Dave|||Check this link, it may be of relevance to your situation.
Resore database with corrupted log file (http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=uXRytePVCHA.2452%40tkmsftngp09&rnum=4)|||Hey...Thank a lot...
even process in bertween a lot of error reported but it still work. Now i can access to my database now...
Thanks. Very appreciated..
We started out with only the MDF file. The log file had been corrupted and lost due to disk failure and we found out we weren't backing up the
databases, only the file groups so we had a month of semi-useless backups.
Definitions:
<databasename> - this should be replaced, in any query detailed in the steps
below, with the database being recovered.
<database path> - this should be replaced with the path to the SQL data
files.
<database logfile> - this should be replaced with the filename of the SQL
database log file minus the extenstion.
1. In SQL Enterprise Manager, create a new database with the same name as
the old one. Make it the same data file size or larger as the old MDF.
2. Stop SQL Server.
3. Delete the new MDF file and rename the old one back.
4. Start SQL Server. The database should now show up tagged Suspect in
Enterprise Manager.
5. In SQL Query Analyser:
use master
go
sp_configure 'allow', 1
go
reconfigure with override
go
update sysdatabases set status=32768 where name='<databasename>'
go
dbcc rebuild_log('<databasename>','<database path>\<database
logfile>1.ldf')
go
NOTE: the second to last command is not a typo. The last variable of
<databselogfile>1.ldf is correct. If your database was named CONTACTS this
would give you CONTACTS_LOG1.ldf. Don't forget the '1' at the end.
This should result in a message similar to, "Transaction log successfully
rebuilt - transactional consistency lost."
6. In SQL Query Analyzer:
dbcc checkdb('<databasename>')
This may result in a number of errors. If so, go to step 7. If there are no
errors, the process may be complete. Check step 9.
7. In SQL Query Analyzer:
dbcc checkdb('<databasename>',repair_allow_data_loss)
You may have to set the database to single user for this to work. It will
alert you to this. This can be done in Enterprise Manager under the
databases properties.
8. Repeat steps 9 and 10 until step 9 results in no errors.
9. The database may end up with a status of "dbo use only". To clear this,
execute the following in SQL Query Analyzer:
use master
go
exec sp_dboption '<databasename>', 'dbo use only', 'false'
go
You can also do this last step in Enterprise Manager under the databases
properties.
I am reinstall my OS (Win2k Server) and try to attach back my database to SQL Server (MS SQL 2000).
After selecting MDF and LDF file. It come out with all those message below in my event viwer. And attach database action is fail.
I had check with Microsoft and download the latest Server Pack 3, but still nothing is change. I am panic here.
Can any one help me to solve this problem.
Your help is very much appreciated.
Thank you.
Dave
Message copy from Event Viwer.
17052 :
Device activation error. The physical file name 'C:\Program Files\Microsoft SQL Server\MSSQL\data\ultra_Log.LDF' may be incorrect.
Error: 823, Severity: 24, State: 6
I/O error (torn page) detected during read at offset 0000000000000000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\ultra_Log.LDF'.
17207 :
udopen: Operating system error 5(error not found) during the creation/opening of physical device C:\Program Files\Microsoft SQL Server\MSSQL\data\ultra_Data.MDF.
17204 :
FCB::Open failed: Could not open device C:\Program Files\Microsoft SQL Server\MSSQL\data\ultra_Data.MDF for virtual device number (VDN) 1.
17052 :
Device activation error. The physical file name 'C:\Program Files\Microsoft SQL Server\MSSQL\data\ultra_Data.MDF' may be incorrect.Judging from the error messages, are you certain you have the files in the correct path? Just trying to eliminate the obvious, here.|||Originally posted by MCrowley
Judging from the error messages, are you certain you have the files in the correct path? Just trying to eliminate the obvious, here.
Well....i just copy back the file to C:\Program Files\Microsoft SQL Server\MSSQL\Data
so....i just using the utility in the Enterprise Manager call Attach Database...is something like sp_attach_db but in windows graphic mode...
even i am using sp_attach_db command in command prompt, same mssg will appear...
here by i submit my database file...the log file and the data file...
please help to solve it...
i have no idea about all this...
thank you so much
Dave|||Check this link, it may be of relevance to your situation.
Resore database with corrupted log file (http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=uXRytePVCHA.2452%40tkmsftngp09&rnum=4)|||Hey...Thank a lot...
even process in bertween a lot of error reported but it still work. Now i can access to my database now...
Thanks. Very appreciated..
We started out with only the MDF file. The log file had been corrupted and lost due to disk failure and we found out we weren't backing up the
databases, only the file groups so we had a month of semi-useless backups.
Definitions:
<databasename> - this should be replaced, in any query detailed in the steps
below, with the database being recovered.
<database path> - this should be replaced with the path to the SQL data
files.
<database logfile> - this should be replaced with the filename of the SQL
database log file minus the extenstion.
1. In SQL Enterprise Manager, create a new database with the same name as
the old one. Make it the same data file size or larger as the old MDF.
2. Stop SQL Server.
3. Delete the new MDF file and rename the old one back.
4. Start SQL Server. The database should now show up tagged Suspect in
Enterprise Manager.
5. In SQL Query Analyser:
use master
go
sp_configure 'allow', 1
go
reconfigure with override
go
update sysdatabases set status=32768 where name='<databasename>'
go
dbcc rebuild_log('<databasename>','<database path>\<database
logfile>1.ldf')
go
NOTE: the second to last command is not a typo. The last variable of
<databselogfile>1.ldf is correct. If your database was named CONTACTS this
would give you CONTACTS_LOG1.ldf. Don't forget the '1' at the end.
This should result in a message similar to, "Transaction log successfully
rebuilt - transactional consistency lost."
6. In SQL Query Analyzer:
dbcc checkdb('<databasename>')
This may result in a number of errors. If so, go to step 7. If there are no
errors, the process may be complete. Check step 9.
7. In SQL Query Analyzer:
dbcc checkdb('<databasename>',repair_allow_data_loss)
You may have to set the database to single user for this to work. It will
alert you to this. This can be done in Enterprise Manager under the
databases properties.
8. Repeat steps 9 and 10 until step 9 results in no errors.
9. The database may end up with a status of "dbo use only". To clear this,
execute the following in SQL Query Analyzer:
use master
go
exec sp_dboption '<databasename>', 'dbo use only', 'false'
go
You can also do this last step in Enterprise Manager under the databases
properties.
ms sql dts package
I created a DTS package, which has a vbscript file to create a new directory, when i run it directly from the command line “DOS” C:\>dtsrun /Sxxxxxxxx /u!xxxx /pxxxxxx /NZOOT_NDM_COPY_and_ZIP_SCORECARD
, I get:
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSActiveScriptTask_3
DTSRun OnFinish: DTSStep_DTSActiveScriptTask_3
DTSRun OnStart: DTSStep_DTSActiveScriptTask_1
DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
DTSRun OnStart: DTSStep_DTSActiveScriptTask_2
DTSRun OnError: DTSStep_DTSActiveScriptTask_2, Error = -2147220482 (800403FE)
Error string: Error Code: 0
Error Source= Microsoft VBScript runtime error
Error Description: Path not found
Error on Line 12
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 4500
Error Detail Records:
Error: -2147220482 (800403FE); Provider Error: 0 (0)
Error string: Error Code: 0
Error Source= Microsoft VBScript runtime error
Error Description: Path not found
Error on Line 12
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 4500
DTSRun OnFinish: DTSStep_DTSActiveScriptTask_2
Error: -2147220440 (80040428); Provider Error: 0 (0)
Error string: Package failed because Step 'DTSStep_DTSActiveScriptTask_2' failed.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 700
'************************************************* *********************
' Visual Basic ActiveX Script
'************************************************* ***********************
Function Main()
Dim fso,f1,f8,s,fldr,drv,fc,f
Set fso = CreateObject("Scripting.FileSystemObject")
f8 = DTSGlobalVariables("DATA_PATH").Value
' CREATE TODAYS FOLDER
if fso.FolderExists(f8&"\ZOOT_"&FormatDateTime(now,VBSHORTDATE)) then = LINE 12
'msgbox "directory Exists"
else
fso.CreateFolder (f8&"\ZOOT_"&FormatDateTime(now,VBSHORTDATE))
end if
' LOOP Through Files
'Change to a variable
Set f = fso.GetFolder(f8)
Set fc = f.Files
For Each f1 in fc
if cdate(left(f1.DateLastModified,10)) = cdate(datevalue(NOW)) then
f1.move (f8& "\ZOOT_"&FormatDateTime(now,VBSHORTDATE) &"\"&f1.name)
end if
' msgbox f1.name
Next
Main = DTSTaskExecResult_Success
End FunctionPlease verify the following:
Have you created a DTS from you EM Client or directly on the server ?
If this is the scenario then it gives you error. Instead of specifying the path like "c:\foldername\" try to give the UNC e.g \\servername\foldername"
May be it will help you
Thanks|||And ensure login used to execute the package has required privilege to complete the task or if you've scheduled same for the SQLAgent service account.
, I get:
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSActiveScriptTask_3
DTSRun OnFinish: DTSStep_DTSActiveScriptTask_3
DTSRun OnStart: DTSStep_DTSActiveScriptTask_1
DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1
DTSRun OnStart: DTSStep_DTSActiveScriptTask_2
DTSRun OnError: DTSStep_DTSActiveScriptTask_2, Error = -2147220482 (800403FE)
Error string: Error Code: 0
Error Source= Microsoft VBScript runtime error
Error Description: Path not found
Error on Line 12
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 4500
Error Detail Records:
Error: -2147220482 (800403FE); Provider Error: 0 (0)
Error string: Error Code: 0
Error Source= Microsoft VBScript runtime error
Error Description: Path not found
Error on Line 12
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 4500
DTSRun OnFinish: DTSStep_DTSActiveScriptTask_2
Error: -2147220440 (80040428); Provider Error: 0 (0)
Error string: Package failed because Step 'DTSStep_DTSActiveScriptTask_2' failed.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 700
'************************************************* *********************
' Visual Basic ActiveX Script
'************************************************* ***********************
Function Main()
Dim fso,f1,f8,s,fldr,drv,fc,f
Set fso = CreateObject("Scripting.FileSystemObject")
f8 = DTSGlobalVariables("DATA_PATH").Value
' CREATE TODAYS FOLDER
if fso.FolderExists(f8&"\ZOOT_"&FormatDateTime(now,VBSHORTDATE)) then = LINE 12
'msgbox "directory Exists"
else
fso.CreateFolder (f8&"\ZOOT_"&FormatDateTime(now,VBSHORTDATE))
end if
' LOOP Through Files
'Change to a variable
Set f = fso.GetFolder(f8)
Set fc = f.Files
For Each f1 in fc
if cdate(left(f1.DateLastModified,10)) = cdate(datevalue(NOW)) then
f1.move (f8& "\ZOOT_"&FormatDateTime(now,VBSHORTDATE) &"\"&f1.name)
end if
' msgbox f1.name
Next
Main = DTSTaskExecResult_Success
End FunctionPlease verify the following:
Have you created a DTS from you EM Client or directly on the server ?
If this is the scenario then it gives you error. Instead of specifying the path like "c:\foldername\" try to give the UNC e.g \\servername\foldername"
May be it will help you
Thanks|||And ensure login used to execute the package has required privilege to complete the task or if you've scheduled same for the SQLAgent service account.
Friday, March 9, 2012
ms sql data tool
hi, Anyone knows what ms sqlem - data tools is in trace file i caught,
appliactionName field
Thanks,Enterprise Mangler...
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"mecn" <mecn2002@.yahoo.com> wrote in message
news:ued3ZXf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
> hi, Anyone knows what ms sqlem - data tools is in trace file i caught,
> appliactionName field
> Thanks,
>|||how could Enterprise Mangler...do the select * from a table?
Thanks
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:%23YHkUbf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
> Enterprise Mangler...
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:ued3ZXf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
>|||Some uses it to open a table. (Behind the scenes it executes the query
"SELECT * FROM table"
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"mecn" <mecn2002@.yahoo.com> wrote in message
news:O4UIQdf$GHA.4496@.TK2MSFTNGP02.phx.gbl...
> how could Enterprise Mangler...do the select * from a table?
>
> Thanks
> "Arnie Rowland" <arnie@.1568.com> wrote in message
> news:%23YHkUbf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
>|||> how could Enterprise Mangler...do the select * from a table?
By right-clicking a table name and selecting "open table"|||Got it, Thanks,
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:%23hq%23fhf$GHA.3308@.TK2MSFTNGP03.phx.gbl...
> Some uses it to open a table. (Behind the scenes it executes the query
> "SELECT * FROM table"
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:O4UIQdf$GHA.4496@.TK2MSFTNGP02.phx.gbl...
>
appliactionName field
Thanks,Enterprise Mangler...
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"mecn" <mecn2002@.yahoo.com> wrote in message
news:ued3ZXf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
> hi, Anyone knows what ms sqlem - data tools is in trace file i caught,
> appliactionName field
> Thanks,
>|||how could Enterprise Mangler...do the select * from a table?
Thanks
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:%23YHkUbf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
> Enterprise Mangler...
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:ued3ZXf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
>|||Some uses it to open a table. (Behind the scenes it executes the query
"SELECT * FROM table"
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"mecn" <mecn2002@.yahoo.com> wrote in message
news:O4UIQdf$GHA.4496@.TK2MSFTNGP02.phx.gbl...
> how could Enterprise Mangler...do the select * from a table?
>
> Thanks
> "Arnie Rowland" <arnie@.1568.com> wrote in message
> news:%23YHkUbf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
>|||> how could Enterprise Mangler...do the select * from a table?
By right-clicking a table name and selecting "open table"|||Got it, Thanks,
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:%23hq%23fhf$GHA.3308@.TK2MSFTNGP03.phx.gbl...
> Some uses it to open a table. (Behind the scenes it executes the query
> "SELECT * FROM table"
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:O4UIQdf$GHA.4496@.TK2MSFTNGP02.phx.gbl...
>
ms sql data tool
hi, Anyone knows what ms sqlem - data tools is in trace file i caught,
appliactionName field
Thanks,Enterprise Mangler...
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"mecn" <mecn2002@.yahoo.com> wrote in message
news:ued3ZXf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
> hi, Anyone knows what ms sqlem - data tools is in trace file i caught,
> appliactionName field
> Thanks,
>|||how could Enterprise Mangler...do the select * from a table?
Thanks
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:%23YHkUbf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
> Enterprise Mangler...
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:ued3ZXf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
>> hi, Anyone knows what ms sqlem - data tools is in trace file i caught,
>> appliactionName field
>> Thanks,
>|||Some uses it to open a table. (Behind the scenes it executes the query
"SELECT * FROM table"
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"mecn" <mecn2002@.yahoo.com> wrote in message
news:O4UIQdf$GHA.4496@.TK2MSFTNGP02.phx.gbl...
> how could Enterprise Mangler...do the select * from a table?
>
> Thanks
> "Arnie Rowland" <arnie@.1568.com> wrote in message
> news:%23YHkUbf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
>> Enterprise Mangler...
>> --
>> Arnie Rowland, Ph.D.
>> Westwood Consulting, Inc
>> Most good judgment comes from experience.
>> Most experience comes from bad judgment.
>> - Anonymous
>> You can't help someone get up a hill without getting a little closer to
>> the top yourself.
>> - H. Norman Schwarzkopf
>>
>> "mecn" <mecn2002@.yahoo.com> wrote in message
>> news:ued3ZXf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
>> hi, Anyone knows what ms sqlem - data tools is in trace file i caught,
>> appliactionName field
>> Thanks,
>>
>|||> how could Enterprise Mangler...do the select * from a table?
By right-clicking a table name and selecting "open table"|||Got it, Thanks,
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:%23hq%23fhf$GHA.3308@.TK2MSFTNGP03.phx.gbl...
> Some uses it to open a table. (Behind the scenes it executes the query
> "SELECT * FROM table"
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:O4UIQdf$GHA.4496@.TK2MSFTNGP02.phx.gbl...
>> how could Enterprise Mangler...do the select * from a table?
>>
>> Thanks
>> "Arnie Rowland" <arnie@.1568.com> wrote in message
>> news:%23YHkUbf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
>> Enterprise Mangler...
>> --
>> Arnie Rowland, Ph.D.
>> Westwood Consulting, Inc
>> Most good judgment comes from experience.
>> Most experience comes from bad judgment.
>> - Anonymous
>> You can't help someone get up a hill without getting a little closer to
>> the top yourself.
>> - H. Norman Schwarzkopf
>>
>> "mecn" <mecn2002@.yahoo.com> wrote in message
>> news:ued3ZXf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
>> hi, Anyone knows what ms sqlem - data tools is in trace file i caught,
>> appliactionName field
>> Thanks,
>>
>>
>
appliactionName field
Thanks,Enterprise Mangler...
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"mecn" <mecn2002@.yahoo.com> wrote in message
news:ued3ZXf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
> hi, Anyone knows what ms sqlem - data tools is in trace file i caught,
> appliactionName field
> Thanks,
>|||how could Enterprise Mangler...do the select * from a table?
Thanks
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:%23YHkUbf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
> Enterprise Mangler...
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:ued3ZXf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
>> hi, Anyone knows what ms sqlem - data tools is in trace file i caught,
>> appliactionName field
>> Thanks,
>|||Some uses it to open a table. (Behind the scenes it executes the query
"SELECT * FROM table"
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"mecn" <mecn2002@.yahoo.com> wrote in message
news:O4UIQdf$GHA.4496@.TK2MSFTNGP02.phx.gbl...
> how could Enterprise Mangler...do the select * from a table?
>
> Thanks
> "Arnie Rowland" <arnie@.1568.com> wrote in message
> news:%23YHkUbf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
>> Enterprise Mangler...
>> --
>> Arnie Rowland, Ph.D.
>> Westwood Consulting, Inc
>> Most good judgment comes from experience.
>> Most experience comes from bad judgment.
>> - Anonymous
>> You can't help someone get up a hill without getting a little closer to
>> the top yourself.
>> - H. Norman Schwarzkopf
>>
>> "mecn" <mecn2002@.yahoo.com> wrote in message
>> news:ued3ZXf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
>> hi, Anyone knows what ms sqlem - data tools is in trace file i caught,
>> appliactionName field
>> Thanks,
>>
>|||> how could Enterprise Mangler...do the select * from a table?
By right-clicking a table name and selecting "open table"|||Got it, Thanks,
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:%23hq%23fhf$GHA.3308@.TK2MSFTNGP03.phx.gbl...
> Some uses it to open a table. (Behind the scenes it executes the query
> "SELECT * FROM table"
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:O4UIQdf$GHA.4496@.TK2MSFTNGP02.phx.gbl...
>> how could Enterprise Mangler...do the select * from a table?
>>
>> Thanks
>> "Arnie Rowland" <arnie@.1568.com> wrote in message
>> news:%23YHkUbf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
>> Enterprise Mangler...
>> --
>> Arnie Rowland, Ph.D.
>> Westwood Consulting, Inc
>> Most good judgment comes from experience.
>> Most experience comes from bad judgment.
>> - Anonymous
>> You can't help someone get up a hill without getting a little closer to
>> the top yourself.
>> - H. Norman Schwarzkopf
>>
>> "mecn" <mecn2002@.yahoo.com> wrote in message
>> news:ued3ZXf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
>> hi, Anyone knows what ms sqlem - data tools is in trace file i caught,
>> appliactionName field
>> Thanks,
>>
>>
>
ms sql data tool
hi, Anyone knows what ms sqlem - data tools is in trace file i caught,
appliactionName field
Thanks,
Enterprise Mangler...
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"mecn" <mecn2002@.yahoo.com> wrote in message
news:ued3ZXf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
> hi, Anyone knows what ms sqlem - data tools is in trace file i caught,
> appliactionName field
> Thanks,
>
|||how could Enterprise Mangler...do the select * from a table?
Thanks
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:%23YHkUbf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
> Enterprise Mangler...
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:ued3ZXf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
>
|||Some uses it to open a table. (Behind the scenes it executes the query
"SELECT * FROM table"
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"mecn" <mecn2002@.yahoo.com> wrote in message
news:O4UIQdf$GHA.4496@.TK2MSFTNGP02.phx.gbl...
> how could Enterprise Mangler...do the select * from a table?
>
> Thanks
> "Arnie Rowland" <arnie@.1568.com> wrote in message
> news:%23YHkUbf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
>
|||> how could Enterprise Mangler...do the select * from a table?
By right-clicking a table name and selecting "open table"
|||Got it, Thanks,
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:%23hq%23fhf$GHA.3308@.TK2MSFTNGP03.phx.gbl...
> Some uses it to open a table. (Behind the scenes it executes the query
> "SELECT * FROM table"
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:O4UIQdf$GHA.4496@.TK2MSFTNGP02.phx.gbl...
>
appliactionName field
Thanks,
Enterprise Mangler...
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"mecn" <mecn2002@.yahoo.com> wrote in message
news:ued3ZXf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
> hi, Anyone knows what ms sqlem - data tools is in trace file i caught,
> appliactionName field
> Thanks,
>
|||how could Enterprise Mangler...do the select * from a table?
Thanks
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:%23YHkUbf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
> Enterprise Mangler...
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:ued3ZXf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
>
|||Some uses it to open a table. (Behind the scenes it executes the query
"SELECT * FROM table"
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"mecn" <mecn2002@.yahoo.com> wrote in message
news:O4UIQdf$GHA.4496@.TK2MSFTNGP02.phx.gbl...
> how could Enterprise Mangler...do the select * from a table?
>
> Thanks
> "Arnie Rowland" <arnie@.1568.com> wrote in message
> news:%23YHkUbf$GHA.3572@.TK2MSFTNGP02.phx.gbl...
>
|||> how could Enterprise Mangler...do the select * from a table?
By right-clicking a table name and selecting "open table"
|||Got it, Thanks,
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:%23hq%23fhf$GHA.3308@.TK2MSFTNGP03.phx.gbl...
> Some uses it to open a table. (Behind the scenes it executes the query
> "SELECT * FROM table"
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:O4UIQdf$GHA.4496@.TK2MSFTNGP02.phx.gbl...
>
Ms Sql Blob ?
Hi to all
I'm starting ussing Microsoft SQL2000, and i need help about how to insert any type of data file( .xls,.pdf, .jpg, .txt, ...) Into a column to extract later the files on web.
I heared about data tipe BLOB, but i can't find the way to work with it...
I'm lost... some body can help me?
Thanks.I struggled for a long time to try to store images in the SQL 2000 database. After long hours and many frustrations, I decided to leave these kinds of files in the capable hands of the file system. Once I did that, life got a lot easier.
Ling
Wednesday, March 7, 2012
MS SQL 2k db and damaged log file
Hi ALL,
I would like to attache my data base but I have damaged log file. Could
some one explain how to play with such a DB ? Does anyone know howto dump
data from *.mdb file without MS SQL 2k server ?
Regards,
Fibre Optic
..mdb is a MS Access file. Did you mean mdf?
I can't help to notice the similarity in your problem with another post that
was made recently... In addition to having a similar problem you both have
fictional names.
The other post:
Homer J. Simpson <root@.127.0.0.1>
Can't attach to database...
Monday, March 21, 2005 8:19 AM
microsoft.public.sqlserver.newusers
Keith
"Fibre Optic" <fibre_optic@.go2.pl> wrote in message
news:d1rovc$5gg$1@.inews.gazeta.pl...
> Hi ALL,
> I would like to attache my data base but I have damaged log file. Could
> some one explain how to play with such a DB ? Does anyone know howto dump
> data from *.mdb file without MS SQL 2k server ?
> Regards,
> Fibre Optic
>
|||I would try using sp_attach_single_file_db first and if that doesn't work
then have a look here:
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
Andrew J. Kelly SQL MVP
"Fibre Optic" <fibre_optic@.go2.pl> wrote in message
news:d1rovc$5gg$1@.inews.gazeta.pl...
> Hi ALL,
> I would like to attache my data base but I have damaged log file. Could
> some one explain how to play with such a DB ? Does anyone know howto dump
> data from *.mdb file without MS SQL 2k server ?
> Regards,
> Fibre Optic
>
|||Fibre
Detach the database and remove the log file. Then attach the database with
single file (for more details please refer to the BOL)
"Fibre Optic" <fibre_optic@.go2.pl> wrote in message
news:d1rovc$5gg$1@.inews.gazeta.pl...
> Hi ALL,
> I would like to attache my data base but I have damaged log file. Could
> some one explain how to play with such a DB ? Does anyone know howto dump
> data from *.mdb file without MS SQL 2k server ?
> Regards,
> Fibre Optic
>
|||answer inline
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uGOFrr6LFHA.3788@.tk2msftngp13.phx.gbl...
> Fibre
> Detach the database and remove the log file. Then attach the database with
> single file (for more details please refer to the BOL)
>
The DB is deattached and I can not attache the db due to damage of log
file. I found such a useful soft:
http://officerecovery.com/mssql/?submit#express
Thanks a lot for ALL answers !!!
Regards,
Fibre Optic
I would like to attache my data base but I have damaged log file. Could
some one explain how to play with such a DB ? Does anyone know howto dump
data from *.mdb file without MS SQL 2k server ?
Regards,
Fibre Optic
..mdb is a MS Access file. Did you mean mdf?
I can't help to notice the similarity in your problem with another post that
was made recently... In addition to having a similar problem you both have
fictional names.
The other post:
Homer J. Simpson <root@.127.0.0.1>
Can't attach to database...
Monday, March 21, 2005 8:19 AM
microsoft.public.sqlserver.newusers
Keith
"Fibre Optic" <fibre_optic@.go2.pl> wrote in message
news:d1rovc$5gg$1@.inews.gazeta.pl...
> Hi ALL,
> I would like to attache my data base but I have damaged log file. Could
> some one explain how to play with such a DB ? Does anyone know howto dump
> data from *.mdb file without MS SQL 2k server ?
> Regards,
> Fibre Optic
>
|||I would try using sp_attach_single_file_db first and if that doesn't work
then have a look here:
http://www.sqlservercentral.com/scri...p?scriptid=599
Restoring a .mdf
Andrew J. Kelly SQL MVP
"Fibre Optic" <fibre_optic@.go2.pl> wrote in message
news:d1rovc$5gg$1@.inews.gazeta.pl...
> Hi ALL,
> I would like to attache my data base but I have damaged log file. Could
> some one explain how to play with such a DB ? Does anyone know howto dump
> data from *.mdb file without MS SQL 2k server ?
> Regards,
> Fibre Optic
>
|||Fibre
Detach the database and remove the log file. Then attach the database with
single file (for more details please refer to the BOL)
"Fibre Optic" <fibre_optic@.go2.pl> wrote in message
news:d1rovc$5gg$1@.inews.gazeta.pl...
> Hi ALL,
> I would like to attache my data base but I have damaged log file. Could
> some one explain how to play with such a DB ? Does anyone know howto dump
> data from *.mdb file without MS SQL 2k server ?
> Regards,
> Fibre Optic
>
|||answer inline
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uGOFrr6LFHA.3788@.tk2msftngp13.phx.gbl...
> Fibre
> Detach the database and remove the log file. Then attach the database with
> single file (for more details please refer to the BOL)
>
The DB is deattached and I can not attache the db due to damage of log
file. I found such a useful soft:
http://officerecovery.com/mssql/?submit#express
Thanks a lot for ALL answers !!!
Regards,
Fibre Optic
Subscribe to:
Posts (Atom)