Yes my friend this is possible :

let me give you an example :

create table mytestdb

go

create table test (t1 int)

create table test1 (t1 int)

create table test2 (t1 int)

then i...

Or we can say like this (i shoudl have modified my sentence in the begening itself ).The only reason to backup the reportservertempdb is to avoid having to recreate it...

also check the error logs and copy the errors here if any ......

totally agreed to what Paul says ...

When you run checkdb its gonna create a sparse file so that msdb can be used by users while checkdb is running ..

Latch waits...

you asked the question and gave the answer as well ...;-)

in short Its not needed ...

give us the query and the columns on which the indexes have been defined ...

Do you have the profile/account created .above all do you have outlook on your machine ..

If not it will not work .

You need to be able to access your exchange...

The error itsself gives you the hint 🙂

I did the repro :

CREATE DATABASE TEST;

CREATE TABLE test1

(t INT)

CREATE DATABASE test1 ON

( NAME = test1, FILENAME = 'E:\TEST_1.SS' )

AS SNAPSHOT OF TEST;

GO

CREATE TABLE test2

(t INT)

CREATE DATABASE TEST2 ON

( NAME...

So you want to run :connect ...got it (if i have not let me know :-))

-> create your script as usual including :connect commands and save it as .sql file...

Analysis Services can address a maximum of 3 GB of memory on any 32-bit version of Windows, regardless of the amount of actual memory that is installed on the computer.Normally...

Step 1:

create a batch file : for eg sqlcmd_start.bat and enter these lines :

cd "Program Files"\"Microsoft SQL Server"\90\Tools\Binn

sqlcmd.exe -E -Sabhay\Orion -q "use master"

The above lines are 2 lines and not...

keith ,

actually the metadata for you data got corrupt .

I have a question .you said that the there are 2 objects : a view and the SP ...does the...

Agreed ..........

Never backup on network share ......

copy it locally and then take it to share or tape .

This is the best practice across all database engines ...be it Oracle ..

Let me correct this statement :

[[[[[[Microsoft will not recognize >16gb with the 3gb switch enabled. For sql server you do not want /3gb enabled. ]]]]

when you enable /PAE the...