Create a view with Schemabinding and they will not be able to rename the table for the first place.

It does not include moving results across the network.

Also Select statement does not "commit" it just reads.

Where do you run Profiler? On the server or on the client?

Read this post here:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1722634&SiteID=1

it says:

"Although you are logged in as an Administrator, in Windows Vista, due to enhanced security features, you need to run the setup or management studio...

Check if this will help you:

Create Table ##TempTable (Id nvarchar(5))

declare @Ids nvarchar(4000)

declare @tempstr nvarchar(4000)

select @Ids = '1,2,3,4,5,6'

select @tempstr = @Ids

WHILE len(@tempstr) > 0

BEGIN

--Printing the current temp string and...

How big is the database? If it is not that big, you can have data exported to the secondary database for reporting and index that second database.

When I install IIS on the servers, it asks about the location of i386 folder. It is normally on the CD so I copy the folder from the CD to...

They will add documents to the projects and it will take a lot of space.

My recommedations will be to store attachments in the file system and path in SQL Server.

This is not the collation, this is the value resolution.

This will work on one value if the previous value was 'a'. What we do is we pre-assign the filed value...

Hi

This is cool!

It is perfectly reproducible. You even don't need Where in the last statement since you have only one row in the table.

This works:

set @cod='A'

update dbo.t1 set c1=@cod

This works...

Make sure the network people update the DNS server with new IPs. Also make sure applications and users connect by name and if somebody or something conencts by IP then...

Did you try to use another job step and shrink the DB not a a part of the maintenance plan but as a job step of the type of Transact-SQL...

Some vendors do need administrative access.

You can deal with it by doing the following:

1. Clear vendor's access with your direct manager and your company network security team.

2. The vendor should...

In the command prompt on server A enter:

telnet ServerArealName 1433

make sure you enter the real name of the server.

if you can ping the server but the command above gives you...

I check that it is the same. Then why did I have to login to my 2000 server to use its BOL to check what it was in 2000?

Well, it...

Linked Server to the cluster or from the cluster to another server?