Hi all,
I want to manage tehnical documents (.dwg, .dxf, .doc, xls, .pdf, ...) with SQL Server. I can use the image data type of DBMS but when the many users store their files in database so it network speed is slow.
Can you show me the way to store and open these files in hard disk of server, and filename path of it on server is stored in table of database.
Thanks
Bear
Hi all,
I have the "Northwind" database in my Sql Server Management Studio Express.
In my C:ProSSEAppsSamplesForChapter02Chapter02 folder, I have the following 2 files:
(1) ListColumnValues (MS-DOS Batch File)
sqlcmd -S .sqlexpress -v DBName = "Northwind" CName = "CompanyName" TName =
"Shippers" -i c:prosseappschapter02ListListColumnVales.sql -o
c:prosseappschapter02ColumnValuesOut.rpt
(2) ListColumnValues (Microsoft SQL Server Query File)
USE $(Northwind)
GO
SELECT $(CompanyName) FROM $(Shippers)
GO
When I ran the following SQLcmd:
C:ProSSEAppsSamplesForChapter02Chapter02>ListColumnValues.bat
I got the following "ColumnValuesOut.rpt" with error messages:
'Northwind' scripting variable not defined.
Msg 102, Level 15, State 1, Server L1P2P3SQLEXPRESS, Line 1
Incorrect syntax near '$'.
'CompanyName' scripting variable not defined.
'Shippers' scripting variable not defined.
Msg 102, Level 15, State 1, Server L1P2P3SQLEXPRESS, Line 1
Incorrect syntax near 'CompanyName'.
I copied these T-SQL statements from a book and I do not know how to correct them.
Please help and tell me how to correct these errors.
Thanks in advance,
Scott Chang
Hi,My webhost (1and1) is running SQL Server 2000 and their web tool supports the import of .bak files. However, when I try to import my .bak files created in SQL Server Management Studio Express I get the following error:"The backed-up database has on-disk structure version 611. The server
supports version 539 and cannot restore or upgrade this database.
RESTORE FILELIST is terminating abnormally."I have Googled this error and learnt that 2005 .bak files are not compatible with 2000 .bak files. I'm just wondering if there are any work arounds to this or alternative tools that I can create 2000 compatible .bak files from from 2000/2005 .mdf files.Thanks in advance.
hello,
I have a question about opening files in the Microsoft SQL Server 2005 Management Studio.
In the old Query Analyzer from SQL 2000 I can open SQL Files via drag & drop (from explorer to QA) or open it with a double click in the explorer. Then the Files opened, if I had actual a connection to a server / database (QA is stared with one file and has a connection to Server/Datebase), with this connection.
Now in Microsoft SQL Server 2005 Management Studio I'll be asked everytime for Server and have to get the database from the database list - it does not connect automaticly to server/database, that is actual connected (I have opened a file with the connection and a connected database in the object explorer).
Someone do not have this problem - but we found no option to set it up.
Any ideas?
thanks &
best regards,
Christian Kiedels
HiI had to recover my computer but before I did that I grabbed a new version of my mdf file but I don't know how to actually import it into SQL Server Management Studio Express evertime I try to open the file up it just crashes. I rather not have to redue that whole database again. I am a noob so step by step instructions are needed. Thanks
View 5 Replies View RelatedHello,
Sorry my newbie question, but I didn't find how to install my ready asp2.0 application (VS2005) to the target Win2003 server. I use SQL Express 2005 both in my dev machine and the Win2003 server. I simply copied all the .aspx and .mdf file there and I made a virtual directory in the server's IIS. My application works corretly without the database, but when I try to log-in it says: wrong user name or password. With Management Studio Express I made a SELECT to see my built-in users (I added these users in my dev machine before the deploying), and I found them correctly. But when I try to log-in via my application it seems as if it would be empty. Then I made a simply page with createUserWizard to try adding new users in the server but the SQL said: the database is read-only (in the IIS I enabled all rights (eg. read, write, run)).
Is there a special way to deploy my SQL file or the whole application? Sorry, I am not enough familiar with it
One of our database is in simple recovery model, and usually generating more than 220 GB log file (.ldf) every week. We are shrinking log file many times to release the space.
But as its not advisable I am looking for any other options. I suggested to change the recovery model to Full and start T-log backup, but client dont want to change recovery model.
Is there any way to manage Log file of Simple recovery model to maintain disk space?
Will full backup truncate log file ?
Hi,
I just started working with Visual Web Devloper 2005 Express Developer and sql server 2005 Express Edition. My web is hosted with 1and1.com. They have informed me that I can't upload the database generated by the developer software and from what I understand, I will import those files into the mssqlserver database on my site. From my limited understanding, this is done from the backup file that is created from my local sql database. I didn't see a way to do that within VWD 2005 so I downloaded SQL Server Management Studio Express. When I opened it I chose the SQLServer (sqlExpress) located on my computer. The connection seems to work fine. However when I go to open a file and open the database that is in my web I get an error that states that there is no editor and to be sure the aplication for file type .mdf has been installed.
I'm not sure where to go from here or if I'm even on the correct path.
Thanks,
Leesha
I have a text file with a bunch of zip codes: 99546,"AK","Adak",162.70,55.20,.0099551,"AK","Akiachak",161.39,60.89,.0099552,"AK","Akiak",161.19,60.89,.0099553,"AK","Akutan",165.78,54.14,.00................... I want to import this in Sql Server Express. Is it possible to do this using Management Studio Express? If not, does anyone know a script that would import the data?
View 3 Replies View RelatedIt works fine and I see the system tables and can make my own tables.
But how do I open a standalone MDF file with it? Or maybe it is a restriction ?
I am trying to get to the database for my personal start kit.
I have a an asp.net application running under IIS. this application is using two folders, the virtual directory under C:Inetpubwwwroot and the application phisical folder at C:.
I want to manage this applications .mdf database using microsoft sql server management studio express(iam running sql express with advanced services) which means i have to attach the database to Ms sql server managemet studio express tool.
What i dont know is if i should attach the .mdf file in the physical folder's App_Data folder at C:myapplicationFolderApp_data or the .mdf file in the virtual directory under C:InetpubwwwrootMyapplicationFolderApp_Data
I dont know which of the two i should attach. Where exactly is the running database, the .mdf file in the physical folder or the .mdf file in the virtual directory under wwwroot.
I have recently installed the SQL Server Management Studio Express but I do not find Management Tools in order to create scheduled backups and shrinking of the databases. I was under the impression that this should be included in the Management Studio. I use the SQL 2005 Express for smaller customers who run the SQL on a desktop unit. I need a way to backup the data to a server machine for backup purposes. I have uninstalled and reinstalled to no avail.
I have a database in my "App_Data" folder of my visual studio project. I can view it fine in Visual Studio's built-in tools for managing a database attached to a solution. However i recently started playing around with the SQL Server Management Studio Express program. When i attach my database to Management Studio, and try to run my program it crashes. I think it might be a permissions error?!? When i detatch it and reattach it in visual studio it runs fine again. Any suggestions? ThanksJason
View 1 Replies View Relatedhi, I have settup up sql mail and did the following:
1. created an E-mail account and configured Out look by creating a pop3 mail profile. tested it by sending and receiving mail, that is ook
2. I Created one domain account for MSsqlserver and Sql Agent service. both services use same account and start automatically in the control panel-services
3. I used the profile that I created in outlook to test the sql mail but got an error:
Error 22030 : A MAPI error ( error number:273) occurred: MapiLogon Ex Failed due to MAPI
Error 273: MAPI Logon Failed
I really do not know what went wrong. I followed the steps from bol and still having a problem. Am I missing something.
I do have a valid email account
I do have a valid domain account
I tested outlook using the email account and it worked. so why sql server does not recognise MAPI.
My next question, How to configure MAPI in Sql server if what I did was wrong.
Hi, I have 2 windows 2000 server in cluster with sql server 2000 enterprise edition installed.
I have activated the Server-Requested Encryption by using the sql server network utility (Force Protocol Encryption). After this, I have stoped sql server service. But I can't start it at this moment.
The error is:
19015: The encrypton is required but no available certificat has been found.
Please help me to start sql server.
Thanks.
Michel
My question is what is the best way to manage the log file size in a Mirrored database session?
Setting log file to autogrow by %
Setting log file to autogrow by mb
Setting log file to restrict growth by %
Setting log file to restrict growth by mb
The above aforementioned followed by a backup log "dbnamehere" with truncate_only, followed by a DBCC SHRINK file I'm assuming is not an option since the log file is constantly being applied to the mirror.
I ask this because I have a DB that can pass some 1,000,000 rows into just one of my tables a day and I need to make sure about this before I flip the switch.
Anyone's help inthis matter is much appreciated.
Thx,
Hi there,
I am just starting to learn SQL 2005 Express. After opening the Management Studio Express, I right Click on the Databases node and create new database. then create a name etc. The problem is that when I click ok to create the new database, I get a warning saying that Input a filename. However when I click on filename (after filepath) it is greyed out and I cant add a filename.
Does anyone know how to remedy this?
Regards
DML
Issue:
SQL Server 2005 Management Studio displays the old filename in the tab at top if you open a .sql file and then do "file save as". I have upgraded to SP2 in hopes that this behavior would be corrected but to no avail.
Hi,
I am trying to connect to a database on a Windows Mobile device using the Management Studio. I am able to select server type "SQl Server Mobile" and navigate to the file on the device. When I try to connect I recieve the following error. Should this work? If so what must I do to allow the registry access?
Thanks,
Ron
Requested registry access is not allowed. (SQL Server Mobile Edition ADO.NET Data Provider)
------------------------------
Program Location:
at Microsoft.SqlServerCe.Client.TdsParser.ThrowExceptionAndWarning()
at Microsoft.SqlServerCe.Client.TdsParser.Connect(String host, SqlCeInternalConnection connHandler, Int32 timeout)
at Microsoft.SqlServerCe.Client.SqlCeEngine.FileExists(String filename)
at Microsoft.SqlServerCe.ManagementUI.Utilities.GetUniqueFilename(String path)
at Microsoft.SqlServerCe.ManagementUI.BrowseForFiles.OnBtnNewDatabaseClick(Object sender, EventArgs e)
Sorry, my question is on SQL Server 6.5
My transaction log is full.
I pushed the Truncate Log button, didn't do anything
I backed up the database (full backup), didn't help
I expanded the Log size from 300MB to 350MB and my 50MB became unavailable in a few seconds.
There is not much current activity out there.
Do you have any ideas how can I fix it?
Any idea on what this error is?I am not able to open Enterprise Manager in SQL server 7.0.Thanks.
View 1 Replies View RelatedHow can I change The model of recuperation from Recovery Full to Simple or to Bulk_logged.
Please,which command can I use on Transact SQL.
Thanks in advance
kinds regards
Abdel
My Database Log file Size Increased dramatically upto 5GB. My Data file size
is only around 600MB. Almost my Harddisk space occupied fully by log file. How I reduce the log file size. Anyone can give me some tips?.
Hi,
I run the following command , it went well but i didnt find
a file authors.txt
where will i find this authors.txt
exec master.. xp_cmdshell "bcp pubs..authors out authors.txt -c
-Sserver -Uuser -Ppwd"
--kavira
hi,
I am trying to create a file using a query in SQL...
kindly help.
Thankyou. --- Vijay
there is a sql.txt file in my c: which grows very fast when i start sqlagent...it keeps occupying the free space in the drive..can anyone please help?
View 4 Replies View RelatedHELP!!!! ARGHHH!!!!!
I can't get this to return the rows, I keep getting 0 rows...
declare @mytime datetime
declare @num_rec integer
set @mytime = getdate()
set @num_rec = (select count(*) from mytable where enter_time <= @mytime)
I've tried '@mytime' also.
No success. Please help
Thanks,
Brian
Hi Everybody,
Our branch office in Europe has sent full 'backup' file of capacity 25GB.
I have to restore this backup to our database. Their database is 'Candidate'
and our database is 'client'. Both these databases have different logical
names and physical names.
The following Batch script only I hv executed,
RESTORE DATABASE Client
FROM DISK = 'd:dumppaw01dump.bak'
WITH MOVE 'candidatedata' TO 'e:mssqldataclient_data.mdf',
MOVE 'candidatelog' TO 'd:mssqllogclient_log.ldf',
REPLACE
Can anybody tell me, what I have executed above is correct or not. Now
restoration is going on for more than an hr. Still it is going on. Is there
any other way to restore this backup set very fastly.
Our server has got very good hardware setup. Good amount of hard disk space.
4GB RAM Memory. Running 4 processors. No other service is running apart from
SQL Server. Right now nobody is accessing the server.
How long it will take to restore this backupset?. This is urgent please.
Any help would be appreciated.
tks in advance,
Sri
I am to create a new file group?Should it be on Primary file group?What is the advantage of having it on Primary File Group?
Thanks
Jai
Hi,
We have to copy data from files from Novell system to Sql sever 2000. I use DTS for that. The problem is that Novell system files(the way they are extracted) has end of file character. Because of this the DTS package fails. But if we open the file, get rid of the end of file character (looks like square in wordpad), the package runs fine.
Is there any way to make DTS identify this character as end of file and ignore it? We have hundreds of files to move on regular basis and some of the files are large (> 10 MB) so that we cannot open it or see it.
Any suggestion will be appreciated.
Hi,
I am trying to import data from a spread sheet to a sql server database... and one of the cells contains which are numeric and only and some are alpha numeric also... but when i try to import them to Sql server i get a NULL in the cells where there is Alpha numeric characters...
I have also tried opening a new spread sheet and setting the format for that particular column and text then i just paste it and then saving,.. but when i try to upload the data i am getting an error (thru my asp.net website) Saying that
No value given for one or more required parameters.
Hope someone can help me solve this.....
Regards
Karen
hi All,
I have a file of 20 GB and need to move this file from my location to machine on client network.
FTP does not work and crash.
IS there a way to move the file??????
it is important....reply.
i am trying to pass a large XML file from VS2005 (web service layer) to stored procedure (SQL Server 2000)In my stored procedure, the input parameter takes as "nText" (which will be XML file)Question:While performing ExecuteNonQuery, i am getting request timeout i think this is coz of large XML file i am passing.can anyone plz tell me how to pass XML file to SP...it would be better if you can provide me with some codei am completely new to this XML file passing between web service and SP...... thanks a lot in advance.....
View 7 Replies View Related