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...
Thanks Frank. These are the articles that I have already read. Are these the only was you can relocate the whole instance ? Rich
Hi, 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...
Hi, 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.
