Developer Newsgroups: SQL Server Tools

Working with image files

LCJ - 23 Dec 2006 1:05 PM - 1 message

Does anyone know of a set of tools (free or for sale) for working with images in SQL. I want the images to remain as files on disk, with a path in the database. I'd like tools to add, delete, change, or view the images. I need to see ...

smo EnumAvailableMedia

ted185 - 22 Dec 2006 4:41 PM - 1 message

If i use server.EnumAvailableMedia to get the list of drives on the sql server In the returned datatable there is a name and lowfree colums Does anyone know how to convert lowfree into meg My drive shows 3894201096 bytes through my computer ...

Full Recovery model and transaction log

fniles - 22 Dec 2006 1:55 PM - 5 messages

When I have a SQL SERVER 2000 database in a Full Recovery model, I notice the transaction log just keep getting bigger and bigger. Will doing a Complete backup and backup the transcation log as part of the maintenance plan truncate the transaction log ? ...

Scripting db creation

mark - 21 Dec 2006 1:28 PM - 6 messages

Does anyone know if it is possible to script the creation of a new database and tables passing a variable that is set as the db name? I have a fairly large script that creates db, tables, users etc but to move from dev to ...

Microsoft SQL Server Management Studio Express Load Error!

Sujata P - 20 Dec 2006 8:02 PM - 2 messages

Hi, I was using MSSMSE till yesterday absolutely with no problem from last 6 months. But suddenly when I tried to open it this morning, it said Package 'Microsoft SQL Management Studio Package' failed to load. Then I reinstalled , (repaired) this package twice. But no luck. Still it ...

SQLDiag on 2005 x64

Ada - 20 Dec 2006 6:54 PM - 1 message

Hi All, I am working on a performance issue on SQL Server 2005 Ent. SP1 x64-bit cluster. I am lack of available tools I used on 2000. How do you handle performance issues on 2005 64-bit? PSSDIAG : not supported ...

Backup using the proxy account in SQL2005

Chris Wood - 19 Dec 2006 8:30 PM - 13 messages

Hi, We want to use the proxy account to take backups created from maintenance plans in SQL2005. What permissions does the proxy account need to do this? It has permissions to run SSIS packages and it failed saying the package ...

default database for opening a .sql file?

Adam J. Schaff - 19 Dec 2006 3:18 PM - 4 messages

I am using SQL Server Management Studio. Whenever I open a .sql file, it does 2 annoying things: 1) prompts me to connect, yet again. 2) sets the database drop down to master again. The second one, in particular, is really annoying. Is there a way to change ...

SQL 2005 Index properties

kzakoski - 18 Dec 2006 10:37 PM - 2 messages

When viewing index properties of an index using SQL Server Management Studio, we see some errors and/or features that are disabled that we once were able to view and change for SQL 2000 and 2005 instances. Options are completely grayed out after applying 2005 SP2 CTP on a client ...

Copy Sql Studio Output to Outlook in HTML? Grids to Excel? What gi

Mike - 18 Dec 2006 4:48 PM - 5 messages

Are there any add-in tools/extensions/fixes available that will let you copy your sql output to Outlook in an HTML table? I could not believe this was not included in Sql 2005 last year. Also, how about being about the ability to copy "grid" output to excel WITH ...

SQL Server 2005 Network Configuration on Server 2003 x64

shariat - 18 Dec 2006 10:51 AM - 2 messages

When I run config manager to configure network option of sql server, it only shows me SQL Server 2005 Network Configuration (32bit) and there is nnothing in it. Why x64 bit is not shown? Is there another way to config network option of my x64 sql server? ...

log ship from SQL 2k to SQL 2k5 with standby

Steve M - 18 Dec 2006 8:24 AM - 2 messages

Hi - I'm trying to do manual log shipping from a SQL 2k Installation to a SQL 2k5 installation. The destination db in SQL 2k5 is at SQL2k compatibility level. I'm trying to restore "with standby" .. and recieve the following error ...

View transaction log file of size 2 gb.

Bhaskara - 18 Dec 2006 6:58 AM - 2 messages

Hi All, I have a log file of size 2 gb. I want to view last month transactions. How can I view this information. When I tryied to open this file, my system/application is hanging as this file is too big. ...