Recent content by LinsLo

This is how I ususally do the backup and restore: 1) Back up the database to a file, you can place the file where ever you want 2) Move the file (if needed) to somewhere where the new server will see it. 3) Then, when you want to restore the new database, restore from type device and then...

I am trying to connect to a remote MSDE SQL database. When I set up the odbc connection I get a connection denied error. The SQL server is on a windows 2003 server. Any ideas are greatly appreciated. Thanks, LinsLo

I am restoring to a blank database. For the database I took the backup from, my data size is 1808MB and my log size is 19236MB. So when I create a new database and name the files appropriatly and try to set the initial size of the files to the values specified above, it throws out an error...

I see that yes, my sizes were completly wrong. But I still get an error when I try to change the size (in MB) to the size which is needed.

I am getting an error when trying to restore a database. The file names and paths look to be correct. The error states that there is insufficient disk space, but the database being restored is 1.4GB and the amount of space on that drive is 17GB, so this should not be an issue. Does any one...

Can you point me in the direction to find this option in Visio? Thanks!!! LinsLo

Can someone help me out with this? I have a SQL database and would like to print out the relationships between all of the tables. The database has a large amount of tables. Any advice would be greatly appreciated! LinsLo

All, I am trying to create a copy of an existing database and place on a different sql server for testing purposes. Currently my method of doing this is to create a backup, then restore a database on my new sql server. But here is the problem I am running into. When I look in Enterprise...

Is is possible to pass an execute procedure statement into a procedure call as an incoming parameter? For example: __________ EXEC Proc_MyProc @ID, @name, EXEC Proc_getContent @ID, @address ________________ Let me know your thoughts. Thanks!

James, Is there any work around for this. Here is the post I just made: Here are the details of what I am trying to do. I have a procedure which has a incoming parameter that is an ID. Based on that ID I want to then perform a select statement that will select a field of type text from a...

Here are the details of what I am trying to do. I have a procedure which has a incoming parameter that is an ID. Based on that ID I want to then perform a select statement that will select a field of type text from a table where a column matches with that ID. Then, I want to call a procedure...