Installing sql server 2005 management studio

I can seem to install this feature of the beta .  All I get is the configuration menu options …

storing image in sql server db

hi all i wont ask how to do it... the thing that i wanna learn is... if i store 500 kb image in my …

Insert Statement error

Im geting this error when im doing my insert statement INSERT statement conflicted with COLUMN FORE…

server stopped listening for connections

i'v set up an sql server 2000 (sp4) instance on a dedicated server. for a long time it has been wo…

Query designer error

I'm trying to write a stored procedure to keep all records together off the ID.  Everytime I t…

How to find out Cascade Foreign Key info

Is there a way to find out if a foreign key is cascade on delete or update? sysforeignkeys doesn't…

TOP Clause functionality within Groups

Hi, Ineed to come up with a TOP 100 by groupings result set. I do not want the TOP 100 records, but…

Linked Server

How to name the Linked server. I have IP address which I link to the server but they change the IP …

date doesn''t change on MDF or LDF

We had to detach and reattach our database on 7/29 - the system has worked fine, however, I just no…

Results of trace 1204?

I ran dbcc traceon (1204) to get deadlock information and used dbcc tracestatus(-1) to ensure that …

Troubles entering data in Enterprise Manager

Hey; I'm having difficulties with data entry in Enterprise Manager (SQL Server 2000).  I was e…

Using June CTP in production unitl November

My systems architect wants to install the June CTP of SQL Server 2005 in a production database serv…

Error 208: Invalid object name ''syspublications'' while running the snapshot

Hello everyone, I created snapshot replication and I'm coming across the Invalid object name while …

Index tuning wizard option gets grey out

Can not update records

I tried running an Update staement and I get "Can not update multiple records." I am trying to set …