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 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 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!
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.