Viewing 15 posts - 496 through 510 (of 1,335 total)
If you have enough time you can read the installation and configuration section in the BOL so that you will be familiar with the procedures and things during installation.
July 17, 2007 at 7:29 am
Could you post the memory details. IS AWE used in the server? IS static memory being used? Size of each database.
July 17, 2007 at 7:27 am
it is to do something with connection pooling check the links given below.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=239567&SiteID=1
July 17, 2007 at 7:08 am
2007-07-16 13:35:12.43 spid4 Input Buf: Language Event: proc_create_fsa_export '20070630','755','Y','html'
2007-07-16 13:35:12.43 spid4 SPID: 74 ECID: 0 Statement Type: UPDATE Line #: 240
2007-07-16 13:35:12.43 spid4 Owner:0x6965bc00 Mode: S Flg:0x0 Ref:0 Life:00000001 SPID:74...
July 17, 2007 at 6:37 am
You will need to apply service packs to the client system running the tools.
July 17, 2007 at 6:32 am
You can do a log shipping between 2000 to 2005 but my advice is never do that it's anyway not going to be used for you incase of a major...
July 17, 2007 at 6:22 am
Only members of sysadmin in sql server will have the option to start/stop the sql server services and since the user you have created has only dbcreate privilege he will...
July 17, 2007 at 5:43 am
If you move DTS by this method make sure that you go and change the connection properties of the each DTS package else they will be pointing to the older...
July 17, 2007 at 5:37 am
Check if shared memory protocol is enabled if not enable it so that you will be able to connect. Also try connecting thru TCP/IP.
July 17, 2007 at 5:24 am
You have to use SSIS to import/export data in sql 2005. They are part of integration services.
July 17, 2007 at 5:23 am
What about my older suggestion. Script the index from the already existing table nad changing the table name and using it again in the destination table.
July 17, 2007 at 5:21 am
Check the syslogins, sys.server_principals views to check for the collation because they store your login info.
July 17, 2007 at 5:19 am
Check if this link help you.
msdn2.microsoft.com/en-us/library/ms180801.aspx
July 17, 2007 at 4:49 am
Even with this script you should be changing the name of the table. Just do that before you run the script.
July 17, 2007 at 3:48 am
select a.*,b.*
from tablea a,tableb b
where a.col1=b.col1 collate collation name
the collation name should correspond to the collation on the column being used in the left hand side. Let me know if...
July 17, 2007 at 3:47 am
Viewing 15 posts - 496 through 510 (of 1,335 total)