Hey,

Not sure about prioritizing which DB has access to varying levels of memory. I believe you just set the memory up for SQL Server as a whole at SQL...

Like Andy Skinner, I am in the position of DBA, SQL Developer as well as VB/ASP Developer as well as Application support from time to time!

Is a bit of a...

Hi Elizabeth,

You just need to modify the @filnameX parameters. For Example...

EXEC sp_detach_db 'pubs'

GO

EXEC sp_attach_db @dbname = N'pubs',

@filename1 = N'e:\MSSQL7\Data\pubs.mdf',

@filename2 = N'l:\MSSQL\Logs\pubs_log.ldf'

GO

In this instance, after you detatch the...

Hey Elizabeth,

You could run sp_detatch_db and then sp_attatch_db and specify the mdf and ldf locations to seperate drives.

Clive

Clive Strong

clivestrong@btinternet.com

Hey Andy,

Not good at all. Unfortunately, I *was* in the same boat. However, the stupidity was down to me. I had no knowledge of SQL Server and...

Tracy,

Yes, you can run DBCC SHRINKFILE while users are accessing the Database.

With regards to the file not shrinking, when you issue the command, SQL tries to shrink the file straight...

Hey,

They are not moved anywhere. They are physically deleted from the TLog. As the Log is backup, it removes all of the commited transactions (inserts, updates & deletes).

The...

Bryan,

When the Transaction Log is backed up, all of the commited transactions in the Log are removed. So the size of the TLog will remain the same, but the...

Hey Junie,

Go to BOL and from the Index tab, type in "Reserved".

Clive

Clive Strong

clivestrong@btinternet.com

Hi,

You can't stop the System Admin account from seeing the data. Also I don't believe there is any kind of encryption/decryption of data within SQL Server.

Could you not have...

Hi Antares & Steve,

In the end, I did reboot the server. There was a block initially from a job that was running, but once I stopped the job, the...

Hey all,

Just figured it myself...Need to get my brain in gear today! I just did not look at the view properly. We have all the data in there to...

Hey Andy,

We have created a view which has all the data we need...However it's grouping it that is the problem! In the view we have...

Account Number

Account Name

Country

Part Number

Quantity Ordered

Sales...

Hey Andy,

We have created a view which has all the data we need...However it's grouping it that is the problem! In the view we have...

Account Number

Account Name

Country

Part Number

Quantity Ordered

Sales...

Hey Ed,

This is possible. A simple syntax would be.

SELECT LEFT(QuestionNumber, CHARINDEX('.', QuestionNumber, 1)-1) As [QuestionNumber]FROM <TableName>

Clive

Clive Strong

clive.strong@btinternet.com