Forum Replies Created

Viewing 15 posts - 556 through 570 (of 643 total)

  • RE: No of Inserted Row "COUNT" Varies

    ns22boss (12/6/2011)

    Here is the connection details

    Connection con = new Connection();

    con.setDbHost("10.60.1.50");

    con.setDriverName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

    con.setDbName("QATESTDB");

    con.setDbUser("sa");

    con.setDbPassword("pa$$word");

    con.setDbPort(1433);

    con.setConnString(ConnectionAction.formConnectionString(con

    .getDriverName(), con.getDbHost() + ":" + con.getDbPort(),

    con.getDbName()));

    ConnectionDetails conAlias = new ConnectionDetails(con

    .getDriverName(), con.getConnString(), con.getDbUser(), con

    .getDbPassword());

    return conAlias;

    You should never post the login credentials on...

    Sujeet Singh

    December 6, 2011 at 5:04 am

    #1417241

  • RE: No of Inserted Row "COUNT" Varies

    ns22boss (12/6/2011)

    Hi,

    How to check that we are using Correct DB connections and DB server.

    Thanks

    1. Verify your connection string properties for Java Console again.

    OR

    2. In the above post, Dev has already...

    Sujeet Singh

    December 6, 2011 at 4:59 am

    #1417236

  • RE: DATABASE REINDEXING JOB FAILS

    THE-FHA (12/6/2011)

    hi,

    i am currently trying to get a script which will do that for multiple databases.

    You can use below script (available on msdn here) to identify the fragmented indexes in...

    Sujeet Singh

    December 6, 2011 at 4:42 am

    #1417214

  • RE: best practice or Standards for Maintanance task planing

    THE-FHA (8/22/2011)

    hi,

    I need the basic standards or rules or steps to follow when creating a maintanace plan.

    1)Firstly which one comes first between dbcc checkdb, Full backup, rebuild index, backup trn...

    Sujeet Singh

    December 6, 2011 at 3:21 am

    #1417184

  • RE: DATABASE REINDEXING JOB FAILS

    THE-FHA (12/6/2011)

    Executing the query "ALTER INDEX [IX_NAME failed with the following error: "The index "IX_NAME" (partition 1) on table "tablename" cannot be reorganized because page level locking is disabled.". Possible...

    Sujeet Singh

    December 6, 2011 at 3:00 am

    #1417168

  • RE: See overview of schedules

    As Tom said you can query sysschedules/sysjobschedules to list out all the schedules you are running the jobs on. In SSMS you can use Job Activity Monitor to see all...

    Sujeet Singh

    December 6, 2011 at 2:48 am

    #1417165

  • RE: TempDB grows when using temporary table within insert sproc

    junk.jjk (12/2/2011)

    Alright, thanks for looking at my code. I'll try letting the tempDb grow for a few days and see if it 'levels-out' at a new, larger size.

    The other...

    Sujeet Singh

    December 6, 2011 at 12:59 am

    #1417127

  • RE: enable filestream

    jcgldr (12/5/2011)

    sorry now i continue to have problems first i was'nt able to create the database with file stream and with your help it worked but now i try to...

    Sujeet Singh

    December 6, 2011 at 12:26 am

    #1417125

  • RE: Unable to import all rows from .csv

    texpic (12/5/2011)

    Why not delete the table and recreate it.

    Using Import/Export Wizard. This is a test database. Taking it straight to the table. I did drop and recreate the table. Same...

    Sujeet Singh

    December 5, 2011 at 11:37 pm

    #1417118

  • RE: Fragmentation using sys.dm_db_index_physical_stats

    Debora (12/5/2011)

    I need help on looking at index fragmentation via sys.dm_db_index_physical_stats. The Avg_fragmentation_in_percent is over 90% for index_id 0 and index_type_desc is Heap. How do I defrag it if...

    Sujeet Singh

    December 5, 2011 at 10:23 pm

    #1417111

  • RE: connection string

    Above provided links are more than sufficient. If you are connecting to a production server & that production server is mirrored on some secondary server for DR purpose (with a...

    Sujeet Singh

    December 5, 2011 at 10:09 pm

    #1417108

  • RE: Disk Space Notification

    alnawrass2002 (12/2/2011)

    Hi

    How can i setup a SQL mail notification when my Database server Disk space is full or near to full?

    By using SQL2008 Management studion

    There are many third party monitoring...

    Sujeet Singh

    December 5, 2011 at 9:53 pm

    #1417107

  • RE: Unable to import all rows from .csv

    Kevin Drysdale (12/5/2011)

    I'm trying to import data from a .csv file into a table and it consistently imports 2033 less rows than the total in the file. I've manipulated the...

    Sujeet Singh

    December 5, 2011 at 9:40 pm

    #1417104

  • RE: not able to connect sql server 2008

    george sibbald (12/5/2011)

    you cannot connect to SQL2008 from SQL2000 tools. You need at least SQL2008 client tools

    We cannot register SQL Server 2008 servers in our SQL Server 2000 Enterprise Manager,...

    Sujeet Singh

    December 5, 2011 at 9:31 pm

    #1417102

  • RE: not able to connect sql server 2008

    Check if you are able to telnet the target SQL Server from the client machine.

    You can check this by issueing this command on CMD on client machine:

    telnet <TargetSQLServerIPAddress> <TargetSQLServerPortNumber>

    Sujeet Singh

    December 5, 2011 at 6:26 am

    #1416638

Viewing 15 posts - 556 through 570 (of 643 total)