SQL Server Tools

hi I have used an agent to do some of my works in sql server with CmdExec job I have set the command of this job with this statement: c:\windows\system32\notepad.exe when I start this job nothing will happen and when I stop this job it says that it is cancelled. ...

In the past I've backed up my systems via maintenance plans that would perform full database backups to disk and having the job place them in separate directories named according to the database name.  Each time the job was run it would create a new uniquely named file ...

hi,  (this is also posted on the vstudio.general group) i installed the SQL 2005 toolkit so i could design reports in VS 2005, with the Business Intelligence project templates. my VS 2005 professional is installed into C:\Program Files\Microsoft Visual ...

Hi; I just installed SqlServer 2005 developer edition and I can't find any way to administer it. There is a "Sql Server Configuration Manager" in the menu but nothing like the Enterprise Manager in SqlServer 2000. What am I missing? ...

Hello Guys,    I need to update from Access a table in SQL SERVER 2005 that contains autogenerated keys. The EM didn't allow me to do so through the import data tool.     Then, my question is Can I do that in SQL SERVER 2005 ?. ...

I have a question about restoring a database using the GUI. If we log in as the db_owner using an SQL account, click on databases and then restore we get the message: "RESTORE cannot process database 'XXX' because it is in use by this session. ...

Hi SQL Gurus, I have a database that has 250 tables.  I need to a 3rd party software that will generate data diagram for me.  I used data diagram from sql but it is useless with a huge amount of tables. ...

Hi, I would like to call an asp page in sql ( probably with xp_cmshell) and read xml response ( from the asp page returns xml format)  and update a table. Would you give an example for this. Thanks ...

This week only, because of the 6-year celebration of our LogManager series, there's a 75% discount on ALL LogManager related products. The LogManager series is a full-featured auditing suite for several database engines, including support for InterBase, Firebird, Advantage ...

I have SQLH2 Performance Collector running against both SQL 2000 and SQL 2005 servers.  The SQL 2000 servers are collecting accurate data for the 'SQLServer: Buffer Manager | Buffer Cache Hit Ratio' counter, but the SQL 2005 Servers are not.  They are getting a value recorded for this counter, ...

Dear Friends, We are happy to announce the new release of Context Database Designer & Database Extensions v.2.11. Context Database Designer & Extensions now supports:   - MS SQL 2000/2005/Express   - MS Access   - Interbase\Firebird (NEW!) ...

Hi I am using Sqlserver 2005 and in management I created some relations. One of them fale with the below error. I have tried to look for unmatched data and dublicates etc, but still keep gettitng this error message. What do you recommend me to do? ...