Search results for query: *

Hi Guys, In Query Analyser, why don't you open up the object browser, right click the table that you want to use as a template, select Script Object to clipboard > create. Paste it wherever and just change the Table name. That way you get all the PK's and indexes that the parent table too...

Hi Vedicman, I am interested in the stored proc that you have mentioned. I need to create a scheduled job that calls a proc that dumps a result set into a .txt or .csv or excel workbook file in a user specifiable location. As an absolute bonus extra, i'd like to be able to append -getdate() to...

EXCELLENT!! THANK YOU I will test this one ASAP (Sorry that I don't have a tidbit useful script to reciprocate with). FYI I have previously asked some colleagues of mine about such a script and I was told that it is in the 'too hard basket' (whether or not they were fobbing me off at the time...

Hi Corran007, Thanks for the advice. Previously, using Query Analyser I have encountererd problems with additional connections (to the DB I want to detach) causinf the sp_detach_db script to fail. Subsequently I have taken to using EM to detach as it has the notify and detach users option...

Hi, We are implementing a SAN solution throughout our network. I am planning on moving the entire contents of an instance to another Server. I need to do this movement with the mininmum of down time as this a production DB for WEB apps and I have to minimize the window of downtime (I think...

Hi Scotty, The cardinal rule of configuring a SQL server is that with datafiles and log files.. 'never the twain shall meet'. Put them on separate disk drives for max performance. Also, consider creating separate file groups and placing them on different drives if you are still having...

Hi, I have detached several databases from an instance using Enterprise Manager. I can move the MDF and LDF files from their original directory to a secondary directory on the same machine, but when I try to move them to another machine (in this case for archiving) I keep getting "can not...

Thanks for the reply BugSlayer. However, my conumdrum is not a SQL code syntax issue. It is the fact that one Server A I can use either 4-part naming convention or OPENQUERY (to access Server B) and on Server B I can only use OPENQUERY (to access Server A).... despite the fact that I have...

I have 2 SQL2000 Servers (A and B) that are on the same Domain and are reciprocally linked (via Linked Server functionality). SQLServer A and SQLServer B use an identically named user account (remote_user) to remotely access each other. This account is a member of the System Administrator's...