Viewing 15 posts - 3,886 through 3,900 (of 7,496 total)
Thank you for your help.
I keep on getting lost whenever xml is being used with cross apply.
How does it retain the correct parent/child dependency ?
I'll try to work on this...
March 19, 2009 at 2:48 pm
Nice article James :w00t:
Good overview towards the remarks and caveats.
We are using MPs for a while now (with sql2005) and didn't encouter any problems yet.
Knock on wood:Whistling:
March 19, 2009 at 2:33 am
SP3 = SP2 + cu9
SP3+CU1 = SP2+CU11 !
You can go directly to sp3 and then apply CU1 for sp3. (Current is CU2)
March 19, 2009 at 1:02 am
rlondon (3/18/2009)
If you decide to set the database to single user mode, don't forget to set it back to multi user mode when finished.ALTER DATABASE [Database_Name] SET MULTI_USER
Keep in mind...
March 18, 2009 at 7:58 am
ronss (3/17/2009)
This is the error I get.Date03/17/2009 1:21:27 PM
LogSQL Server (Current - 03/17/2009 1:21:00 PM)
SourceLogon
Message
Login failed for user 'sa'. [CLIENT: 192.168.76.14]
and the client is the IP address of your sqlserver...
March 17, 2009 at 2:25 pm
It has been a while since i tested with SSMA for access, but I think it has a section to handle this.
March 17, 2009 at 2:23 pm
MS has some good Migration assistant software for MSAccess, ...
Check out http://www.microsoft.com/Sqlserver/2005/en/us/migration.aspx
March 17, 2009 at 10:56 am
Is sqlagent connecting to sqlserver using the sa account or using its service account ?
March 17, 2009 at 10:54 am
what's the purpose of doing that ?
If you don't want backups and you don't want PIT recovery, just put your database in simple recovery.
March 17, 2009 at 10:52 am
First question : Why ?
- don't trust the network people ....that is not an argument
- they don't have a clue about sqlsever and the consequences of the sqlserver related actions...
March 17, 2009 at 4:43 am
I use this script to generate the restore log sequence(s).
(and the header time indication may help to determine which full backup to start from )
March 17, 2009 at 4:33 am
start with setting the current database to another state !
e.g.
Alter database set single_user with rollback immediate
-- don't put GO overhere or you may lose your db connection !! (so...
March 17, 2009 at 4:24 am
Gift Peddie (3/16/2009)
hmm... your db-engine can still be 64-bit and take advantage of all that comes with it !
Maybe the db-level might be kept to 80 (sql2000) for a little...
March 17, 2009 at 12:56 am
Actually you would need to do the same as if you would handle files on "regular" disks.
That goes for :
- raid
- allocation size
- number of files
...
Whenever we move physical files,...
March 16, 2009 at 11:08 am
Gift Peddie (3/16/2009)
March 16, 2009 at 11:01 am
Viewing 15 posts - 3,886 through 3,900 (of 7,496 total)