Developer Newsgroups: SQL Server Tools

setvar is a mystery

ChrisHarrington - 6 Jan 2007 4:03 AM - 2 messages

FROM sys.server_principals WHERE name = $(dbuser2) gives error Msg 126, Level 15, State 1, Line 3 Invalid column name 'myuser' ---------- Chris Harrington Active Interface, LLC. [link] ...

SMO 64-bit feature pack ok side-by-side with 32-bit SQL Server??

smoss - 5 Jan 2007 11:51 PM - 1 message

I'd like to install the 64-bit SMO objects on a 64-bit OS that we have 32-bit SQL Server Instances installed on. I've written an application using SMO to do some scripting and restoring of schemas and permissions, that I want to call using cmdexec on a job. ...

sqlcmd examples

ChrisHarrington - 5 Jan 2007 11:25 PM - 4 messages

I am suprised - Googling found nothing. Does anyone have any sample scripts they can share? Or have pointers to any? Thanks Chris Harrington Active Interface, LLC. [link] ...

SQL Server 2000 Database with DTS Components

fakethingsster - 5 Jan 2007 8:38 PM - 3 messages

I'm planning on moving a database from one SQL Server 2000 server to another [also SQL Server 2000]. The application that relies on this database has a Microsoft Access front-end and relies on some Data Transformation Services components on the database server. I don't ...

VIW file Extension in SQL Management Studio 2005

Techno_Dex - 5 Jan 2007 4:07 PM - 4 messages

Does anyone know how to get the *.viw (Sql View) file extension associated with SQL Management Studio 2005 so that the file opens up prompting for a database login similar to opening up a *.sql. I already have the *.viw file ...

test post

Zoidberg - 5 Jan 2007 3:18 PM - 2 messages

blah ...

SQL Server 2005 - add table window very slow to appear when creating new view

Smitty - 4 Jan 2007 9:40 PM - 2 messages

Has anybody else ran in to the following problem? If so, have you been able to correct it? When you right click on on the Views folder and select new view, the add table window takes 2 to 4 minutes to appear. ...

Maintenance Plan Issues

CK - 4 Jan 2007 5:49 PM - 2 messages

I'm attempting to create a sql 2000 maintenance plan. It keeps failing on me with the following error: Event Type: Warning Event Source: SQLSERVERAGENT Event Category: Job Engine Event ID: 208 Date: 1/2/2007 Time: 11:03:51 AM ...

Status / State of Services in SQL Server 2005 Management Studio

SteveM - 4 Jan 2007 3:17 PM - 2 messages

If I login with my id that has sysadmin priveleges (but no server priveleges), I cannot see the status / state of servers / services (red / green) in SQL Server Management Studio. If I login using an account that has server administrator priveleges, I ...

How Does Management Studio Licencing Work?

NigelA - 3 Jan 2007 6:13 PM - 1 message

A client of mine has recently acquired SQL2005 on one server. I can't seem to find a clear definition of the way the licensing for the client tools - i.e. SQL Server Management Studio and Business Intelligence Studio - works. ...

sqlmaint.exe hangs

Satwinder - 3 Jan 2007 1:55 PM - 3 messages

We use SQL Server 2000 enterprise SP3 on 2 node active/active cluster We have multiple maintenance plans . Single plan contanis multiple databases. One such plan for database txn log backup, takes txn log backup on each database sun-directory, writes history & deletes txn log backup files older ...

Tool to review SQL schema design

Baskar - 3 Jan 2007 12:44 PM - 3 messages

Hi I have created a database with all PK & FK relationship defined for my project. I wanted to make sure that my schema/table design is perfect. Any tool available to review my schema/table design? If yes, kindly send me the ...

ssis issue

gess6321 - 3 Jan 2007 8:48 AM - 2 messages

i am trying to create a job in ssis for a package I created. I able to execute the package, but get the following error when I run the job [298] SQLServer Error: 22046, Encryption error using CryptProtectData. [SQLSTATE 42000] Anybody have any idea how to get around this? ...

How can you use VSS to manage stored procedures

D. Haber - 3 Jan 2007 1:22 AM - 3 messages

Can anyone explain how to use the VSS integration in SSMS to mange stored procedures? We use VSS to manage source code in Visual Studio but I can't figure out how this is done with stored procedures in SMSS ...

SQL MINDS IS A SCAM

Hugh Johnson - 2 Jan 2007 11:40 PM - 1 message

SQL Minds, out of North Carolina, is claiming many things, but not admitting their relaltionship to a STOCK SCAM called Vision Technology Corp. Plamen Slavov (Product Manager) is a realtor from Florida, Ivan Ivanov, CEO is also the CTO of Vision Technology Corp (VSTC), the CEO of ...

SQL Server 2000 client tools and Windows Vista

Kevin - 2 Jan 2007 10:37 PM - 2 messages

Can anyone tell me if SQL Server 2000 client tools such as Enterprise Manager, Query Analyzer, etc. will run on Windows Vista? We have SQL 2K running on a Win 2003 server. I just want to know if a ...

SQLCentric - Monitoring & Alert System - Supports SQL Server 2005!

rsp05 - 2 Jan 2007 3:23 PM - 1 message

Pearl Knowledge Solutions, Inc., is pleased to announce that with the release of v.2.0.1, SQLCentric now support SQL Server 2005! Winner of the 2004 SQL Server Magazine's Reader's Choice award, SQLCentric was voted Best Database-Monitoring Software and Best ...