Looks like your login doesn't have create database privileges. Are you the admin of that server? If not, can you speak with the admin and see if you have the...

When you installed, did you check the option for the client tools? It should be checked by default.

shishirbabel (9/20/2008)

---

1. I am having lengthy tables of up to 50 columns but all these 50 columns will not contain any redundant values so is it a good idea to...

Please don't cross post. It just wastes people's time and fragments replies. Many of us read all the forums

No replies to this thread please, direct replies to:

http://www.sqlservercentral.com/Forums/Topic573066-361-1.aspx

How are you trying to rebuild master?

What does the summary.txt file that the error message references contain?

Well, the as shouldn't be there, you need to alias the open query, the statement within openquery needs to be in quotes, the column sAMAccountName needs to be added to...

sandhyarao49 (9/20/2008)

---

Hi I don't know how to scipt the logins.Could you kindly tell me how to script the logins.

It would be great if you provide the repro steps for the...

DDL rights means that the users will be able to truncate the table, not delete from it (unless they also have delete rights from elsewhere)

Do they really need ddl rights?...

Shrink with the truncate_only command will release unused space at the end of the file to the file system. If the free space within the file is scattered around, as...

Umm.. recursive link. Did you mean here -

http://www.sqlservercentral.com/Forums/Topic572938-359-1.aspx

Mirroring is more an 'automated' logshipping than it is similar to replication.

Replication (transactional) will give you a second server that's fully usable (read and write) that is slightly behind the...

Run profiler for a while and look for queries that have very high CPU usage. Take the top 3 or so and see if you can optimise them. That may...

If you switch to simple recovery, you will no longer be able to run log backups.

Check your log backup job, make sure that no one's added the 'WITH NO_TRUNCATE' clause...

The backup is the size (more or less) of the data in the database, not the file size of the databases. It means that your DBs have some space free...

Why don't you use temp tables, then you will have no such worries. Also means that your users won't need create table rights in your database.

CREATE TABLE #TableName ...

...

DROP TABLE...