|
The command is sp_attach_db. Example:
EXEC sp_attach_db @dbname = N'pubs',
@filename1 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf',
@filename2 = N'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs_log.ldf'
I prefer using a backup/restore approach.
|
|
|
|
|
Thank you my friend,
but my problem is that the Log.ldf file is not found (deleted), so @filename2 is invalid.
Do you have another way ?
|
|
|
|
|
Hello,
I am trying to insert a record in an Access database using Asp.Net/Vb.Net.
I am getting the error: "Operation must use an updateable query."
How can I solve this problem?
The code I am using is:
' Set Connection
Dim connectionString As String = AppSettings("connectionString")
Dim dbConnection As IDbConnection = New OleDbConnection(connectionString)
' Set Query
Dim queryString As String = "INSERT INTO [t_news] ([title_pt-PT], [title_en-GB], [text_pt-PT], [text_en-GB], [publication_date]) VALUES (@title_ptPT, @title_enGB, @text_ptPT, @text_enGB, @publication_date)"
' Set Command
Dim dbCommand As IDbCommand = New OleDbCommand
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection
' Add Parameters
With dbCommand.Parameters
.Add(New OleDbParameter("@title_ptPT", "title PT"))
.Add(New OleDbParameter("@title_enGB", "title GB"))
.Add(New OleDbParameter("@text_ptPT", "text PT"))
.Add(New OleDbParameter("@text_enGB", "text GB"))
.Add(New OleDbParameter("@publication_date", DateTime.Now.ToString("dd-MM-yyyy HH:mm:ss")))
End With
' Insert New Record
dbConnection.Open()
Try
dbCommand.ExecuteNonQuery()
Finally
dbConnection.Close()
End Try
Thank You,
Miguel
|
|
|
|
|
I have created 1 file browse btn from where i am alowing to select the file which has to be uploaded to sql server.. Now i have the Excel file path..
How do i access the file. through Open data source..
I used. sql statement
"select * into abc_data from OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0','Data Source=" & vfilename & "; Extended Properties=Excel 8.0') ...[sheet1$]"
where vfilename is the Excel File Path incl filename.xls.
But it is giving error.. Can anyone help..
Thanks,
Prasanna
|
|
|
|
|
Hello guys!!
What is the minimum time (in ms) required to respond from sql server when data is near @ 1.2 GB
and also where i will get some kind of utility or sql command where i will find
1. Check the space allocated to Database
2. Check the total space remaining in database
1. Check Memory Usage of MSSQL
2. Check CPU Utilization
3. Check Disk contention
1. Use SQL Server profiler
2. Check Trace event, lock event, session event etc
3. Create Trace
1 . Check for memory utilization
2. Check for unwanted process utilizing Memory
3. Check database memory utilization
these factors
T.I.A
Shashank
|
|
|
|
|
Hello
thanks
I checked it with on BOL and got query
SELECT * FROM MASTER..SYSPROCESSES
i got it just few more things i want to clear
1) waittime
2)cpu
3)physical_io
4)memusage
what are units of these columns i.e waittime is in MS (miliseconds or else),
like that cpu?,physical_io? and memusage (i.e in MB or else)
T.I.A
shashank
|
|
|
|
|
Hi all,
I have a Date Format Problem with SQL Server 2000. the Default Date format of Sql server 2000 is MM/DD/YYYY , but i wanna DD/MM/YYYY , So how can i change the Date Format in SQL Server...
Thanx in advance
Sajjad
|
|
|
|
|
I have started storing at as text and casting it to correct date format in the stored proceedures as needed. I find that gets rid of any of the problems with dates which could go either way eg 03/04/2005.
Jon
|
|
|
|
|
SQL stores dates as binary information (assuming you used a datetime field type). The default disply format depends on the installed locale and collation order (and is likely being set by whatever UI you are using to display the dates).
For input of dates as strings, SQL Servers default is US English (mdy) order, but this can be changed with the statement 'Set DateFormat dmy' (for day, month, year order).
You can also use the convert function to convert the stored datetime values to varchar or nvarchar strings before returning the result, specifying the datetime style as a convert parameter "select mydate as convert(varchar(50),[theRealdatefieldName],103) from Mytable"
103 specifies the british dd/mm/yy format. See Sql Books Online help for Convert.
If you are looking at it in a UI (C# form), then you must either change current culture/language setting programatically or in control panel settings...
Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
The opposite of the religious fanatic is not the fanatical atheist but the gentle cynic who cares not whether there is a god or not.
Eric Hoffer
|
|
|
|
|
I want to access some data from other tables while working with data from another table in one application. if I accesss data using table joins, I cant update neither table. e.g If I'am computing a pay of an employee in the Transactions table, and I want to use the basic salary field value in Employee Master table. How can I access this value and use it in the transactions processing application and update the relevant tables there after.
This approcah will enable me make sizable tables in my databaase since I will be able to reference data from various tables while working in one particular application.
I am using Visual C++ 6.0.
Thanks in advance.
|
|
|
|
|
Hi Techies,
Greetings from Joby. I am a .Net/SQL Programmer and in my new project there is an instance where I need to invoke a Java API throug a stored procedure.Can anyone please help me by giving me a clue or some piece of code to do it? I await your valuable suggestions and advices.
Thanks and Regards,
Joby.
|
|
|
|
|
I don't believe this is possible in any direct sort of way. About the best I can think of would be some kludge useing an extended SP with a C dll called by that XSp that in turn invokes the Java runtime with the desired paramters or a com dll with a com-java bridge...or maybe a kludge based on xp_cmdshell.. not fun, and likely fragile.
Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
The opposite of the religious fanatic is not the fanatical atheist but the gentle cynic who cares not whether there is a god or not.
Eric Hoffer
|
|
|
|
|
anyone know how to Syncronised MySql with SQL SERVER
|
|
|
|
|
hi
Usually in Sql Database date is stored in the format of mm:dd:yyyy. I want to store it as dd:mm:yyyy. i want to make it as a permanent setting.
shelly
|
|
|
|
|
|
hi,
i want to remove identity check for a table, i used SET IDENTITY_INSERT ON but it works just for one transaction,how can i disable identity forever
(i need the Transaction for this operation)
|
|
|
|
|
Alter the table, change the identity field to an ordinary integer (remove the identity attribute). Of course you will then be responsible for computing the value for new inserts... You could set a Unique constraint on the field to insure that it still rejects duplicates.
Absolute faith corrupts as absolutely as absolute power
Eric Hoffer
The opposite of the religious fanatic is not the fanatical atheist but the gentle cynic who cares not whether there is a god or not.
Eric Hoffer
|
|
|
|
|
do you receiving error massage?
|
|
|
|
|
i'v been with crystal report last 4 years ,crystal report 8.5 version still stable than crystal report 10 version,i've scene few things that crystal report can fail
1.) once you create or call a crystal report your are not allow to change the order of columns in table that you refer for crystal report,you can add columns to table but always below other columns,cant replace the order.
note :- if you done those things you have to create or call reports again
|
|
|
|
|
Hi for all,
I'm using vs.net 2002 + sql server 2000 desktop engine
and i created an asp.net web application project and i tried to open the connection but i received an error that i can't open the connection :
(Server Error in '/MyWebPage' Application.
Login failed for user 'SMART\ASPNET')
pls anyone know how to solve this problem ?
thanks
|
|
|
|
|
Asp.Net (development or production box) does not run in the same security as you do. It most likely does not have rights to the database. Create a SQL login with the correct rights on the SQL Server and update your connection string.
|
|
|
|
|
thanks for your reply,
but how can i change my logon cuz i don't have any tool for the sql server ?
its sqlserver desktop engine without a tools
thanks again for your replay
|
|
|
|
|
You will have to access via TSQL if you don't have Enterprise Manager.
See:
sp_addlogin
sp_addUser
sp_grantdbaccess
on MSDN as a starting point.
|
|
|
|
|
thanks alot for your info
i installed sql server 2000 enterprise edition but not the server but just the client tools like enterprise manager
cuz the enterprise edition not compatible with my platform
i received a message from the installer that is not compatible with my platform, i use windows xp sp2, and i used the enterprise manager and its a greatful tool and i resolved my problem.
tnanks again
|
|
|
|
|
Hi
I have 3 tables
Product(productID , productName , styleID , artistID )
, Artist(artistID , artistName )
, Style(styleID , styleName ) and relationShips :
Style 1 ---> N Product
Artist 1 ---> N Product
and this Command :
oleDbCommand = new OleDbCommand (
"select Product.productName , Artist.artistName , Style.styleName from ( Product inner join Artist on Product.artistID = Artist.artistID inner join Style on Product.styleID = Style.styleID )where productID = @productID", oleDbConnection );
But I got error :
Syntax error (missing operator) in query expression 'Product.artistID = Artist.artistID inner join Style on Product.styleID = Style.styleID'.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
