Can log shipping monitor server be SQL Server Express Edition?
I couldn't find this information in the books online.
does anyone know if Microsoft supports upgrading from SQL Server 2000 Standard to SQL Server 2005 Standard?, and also attach some links where I...
Yes it has "Log on as a batch job" rights, and also it has system administrator permission in SQL Server
I have SQL Server 2000 (SP4) installed on a windows 2000 server, SqlServer Service and SqlAgent Service are running under a domain account...
Yes, but here's what I'm trying to do,
I have a lookup table which is referenced in many other tables, I thought to make a uddt which is going to be...
Is it possible to modify user defined data types, once they been created?
If yes can someone provide me with some help.
The links above were very halpfull, thanky very much,
is it pssible to move master db to different physical disk?
if yes, then can someone provide with some instructions?
Is there any problem if I use
before sending mail using
I do this because we very...
I'm member of system administrator server roles
and also dbo on both databases
I have two databases DA and DB, I create a stored procedure that selects records from tables on both databases, I save the stored procedure on DA, I...
Is it pssible to move tempdb to anorhter location (another physical disc)?
I thought that I can simply dettach it and attach it to another...
I checked, no dts load, no bulk inserts, only inserts of users that work every day.
I do Fridays Full Database backups, and every day differential...
The filegrowh increment is 10%, I don't have maintenance plan which would recreate indexes by itself,I recreate indexes manualy. Lately I did not do...
I checked the filegrowth and it is set to UnrestrictedFilegrowth, but I don't see any reason to rectrict it.
yesturdaty I truncated Log of our production database, because it growed to 12 GB, and from yesturday till now it growed to 6 GB, can anyone...
yes I ran those commands, I see the objects that are locked, there are 116 objects locked by this process, but I just can not kill this process.
There is a lock that is happening in my server, and when i try to kill it, it does not kill.
and then it shows me a...
yes, but let's say that bothe databases change data, in this case if you do backup on one side and restore in another side, it will overwrite changes...
is it possible to replecate two coputers which are not connected, for instance: they do not have internet connections and they are not...
Separate names with a comma.