Hi,<br /><br />I have been trying to use XP_FILEEXIST to determine if a directory exists. I know I can run it against a file i.e (exec xp_fileexist...
In SQL*PLUS for Oracle there is an ACCEPT command that allows the script to prompt the user for an input.
I was thinking more about a prompt asking for a users input. I can probably do this via a .bat file but was just wondering if it is was possible.
When running a TSQL file is there any way of requesting the user to enter a value for a variable ?
Sorry meant less complex not less easier [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br /><blockquote id="quote"><font size="1"...
At the moment I only have the default databases as I have just re-installed SQL Server.
I understand how to change the location for new database, I...
These are the articles that I have already read.
Are these the only was you can relocate the whole instance ?
I have just installed SQL Server 2000 and the default database directory is "c:sqldatafilessystemMSSQLdata". Is there an easy way to move the...
Anyone got any replies to my second post ?
Thanks for the quick reply,
Here is an example of what I am trying to do :
Database name = TESTDB
DBO = testuser
Currently testuser is the dbo for...
Some databases that I support have owner of the user that created them originally instead of sa.
These databases are production and have...
Separate names with a comma.