SQL Server Tools

Professional web design and other web development services is what Wicked Innovations specializes in, from complex integrated solutions for business and advanced multimedia products. We offer affordable prices, a professional approach and customized solutions for business of all sites. What separates us from the rest is not only we provide a unique and ...

Running SQL Server SP4 / Win2K SP4 Have input file (containing all stored procedures batch separated with GO) of about 7MB.  When running this file using OSQL utility, only about 80% of the objects get applied.  No errors in the output (only sysdepends warnings). ...

I am setting up SQL 2005 server. We are using SQL Mail. I have defined the email operator and defined notifications on a job to send out emails when job completes. The issue is the my outlook client on the server gets locked once sql server ...

Hi, I have a wierd problem when debugging an SP. When using STEP INTO (F11), the debugger steps into commented lines/blank lines. Also, breakpoints are allowed on both commented and blank lines. I'm running SQL server on a non-system account - Checked all the usual ...

I had an earlier item about this in the newsfeed but I can't find it now. The Fonts and Colors dialog in SQL Server 2005 Management Studio is very confusing. When you use Management Studio to open a SQL database, and expand the ...

Within EM i have 2 servers, the maint plan on the first server works fine, the other one will not allow me to select "day/weeks" next to the "remove files older than" box under the complete backup tab. It has sp3, new to this ...

Dear Friends, We are happy to announce the new release of Context Database Designer & Database Extensions v.2.06. Both products are immediately available for download at:    [link] ...

Hello Great range of properties....... check them out....... Rent direct from owners of French gites, farmhouses in Brittany, villas in Provence, luxury lodges on the golf course, Bed and Breakfast in Dordogne, cottage in France , horse trekking holidays in Normandy and more. ...

hi I have 2 databses db1,db2.I want to transfer data from db1.table to db2.table.without using export data method through procedure or sql stmt how can i do it.please help ...

I have backup maintenance plans that fail overnight. The main error refers to database being in single user mode. I will post the complete error message tomorrow. I can do a backup outright to my hard drive but I could not run a ...

Hi all, I am looking for a tool that enables me to create NDoc-style documentation of a database, including a listing of fields and their attributes within tables. It is important that the description of a field is drawn from the ...

I'm using SQL Server 2005 and using Subversion for source code control.  I had been saving some stored procedures from the SQL Server management studio and committing them to the repository with no issue.  I only noticed an issue ...

Hi All I have a plenty of queries, whitch look like these: SELECT A.USERS,A.RECID FROM RUNTABLE A WHERE RUNID=? Instead of actual parameter value they have a '?' sign Is there any possibility to tune such queries in Database Tuning Advisor ...

How can I make an SQL script being executed by SQLCMD to change the current database context dynamically.  The database to use is passed through from the batch file, and therefore dynamic within the script. The script will ultimately create a new database. ...

Hi Is there a simple way of doing a trace with the 2005 express version. I have the full version so I can analyse the trace with that. I am experience performance issues with a very small express database. I downloaded a command utility but can't get it to work ...