Forum Replies Created

Viewing 15 posts - 316 through 330 (of 644 total)

  • RE: can i upgrade sql server 2000 sp2 to sql sevrer 2005 in inplace upgrade?

    s1123 (3/5/2012)

    or

    from server 2000 sp4 to server 2005 only possible

    what i studied is this one

    only 2000 sp4 to 2005 sp4 to 2008.

    but after reading some articles i got...

    March 5, 2012 at 5:15 am

    #1454740

  • RE: SQL Server 2008R2 Ent not using all available memory

    alexanko (3/2/2012)

    Settings:

    SQL:

    Enable AWE Memory for SQL Server

    Maximum server memory (in MB) - 11 000 Mb

    Minimum server memory (in MB) - 11 000 Mb

    I assume you have correctly set the...

    March 5, 2012 at 5:11 am

    #1454735

  • RE: Database Growth

    Ratheesh.K.Nair (3/4/2012)

    Hi experts,

    Is there any way to find out the database growth for the last month even if i dont have any tracking method in place?

    TIA

    Backup history is stored in...

    March 5, 2012 at 5:03 am

    #1454730

  • RE: Need a View into a database on a different instance

    Capt. Sigerson (3/2/2012)

    Thank you very much. I've set up the replication distributor and publisher and subscriber databases but the replication is failing because of a login error when the...

    March 4, 2012 at 1:42 pm

    #1454600

  • RE: Need a View into a database on a different instance

    Capt. Sigerson (3/2/2012)

    The remote table is roughly 70,000 rows.

    Transactional replication should work perfect.

    March 2, 2012 at 8:10 am

    #1454200

  • RE: Need a View into a database on a different instance

    OPENQUERY is an option which can be used to get the data from remote server without using link server, however I would not recommend it as I think link server...

    March 2, 2012 at 7:27 am

    #1454159

  • RE: DBCC Transaction Logs - How to read/interpret

    Klarence A. (3/1/2012)

    Hi Guys,

    How to read/interpret the transaction logs displayed by DBCC command? can I convert the records into human readable format? If so, how?

    Thanks in advance!

    Transaction Log file is...

    March 2, 2012 at 7:17 am

    #1454152

  • RE: connection problems

    patrickdrd (10/7/2008)

    I am running an ASP.NET application. Quite often I am getting random error like the below:

    # Column col does not belong to table Table

    # Cannot find table 0

    # Cannot...

    March 2, 2012 at 6:39 am

    #1454126

  • RE: Linked server on 64 bit Sql Server-2005 for 32 bit Sql Server - 2005

    There should be no problem in configuring or connecting the link server from 64 bit SQL Server to 32 bit SQL Server. It works fine.

    March 2, 2012 at 4:40 am

    #1454094

  • RE: SQL 2005 Clustering issues

    What error do you get in error log?

    March 1, 2012 at 3:56 am

    #1453529

  • RE: quick question on securables

    I am not sure if this is exact solution but I have this idea:

    1. Create a user without login. Suppose you created "ProcUser".

    2. Grant this user execute rights on spClear...

    February 29, 2012 at 8:39 am

    #1453208

  • RE: SQL Server 2008 R2 memory usage

    YaHozna (2/29/2012)

    All the ususal suspects are normal. Memory usage from sys.dm_os_sys_memory tells me the Cached Page Count is 2471715 and 1116275 for the biggest databases. (Is that high?) and The...

    February 29, 2012 at 7:56 am

    #1453182

  • RE: sys.sysprocesses

    Gazareth (2/29/2012)

    Isn't sys.sysprocesses marked for deprecation?

    I use sys.dm_exec_requests/connections/sessions (whichever's appropriate) in its place.

    Yes, It is marked for deprecation. Most of us have already started using sys.dm_exec_sessions & sys.dm_exec_requests instead. However,...

    February 29, 2012 at 7:46 am

    #1453174

  • RE: sys.sysprocesses

    sqlnaive (2/29/2012)

    select a.spid, b.text from sys.sysprocesses a cross apply sys.dm_exec_sql_text(a.sql_handle) b

    This is the query I'm using. This is giving me even those sessions which are closed in query analyzer.

    May be...

    February 29, 2012 at 6:33 am

    #1453128

  • RE: sql server dba

    babuannam.dba (2/29/2012)

    I would like to create 20 databases in an instance and I would like to give same properties to all, How to do in a single shot

    Two ways:

    1. Write...

    February 29, 2012 at 5:59 am

    #1453104

Viewing 15 posts - 316 through 330 (of 644 total)