Forum Replies Created

Viewing 15 posts - 16 through 30 (of 42 total)

  • RE: how to write store procedure

    aarunkumarreddy (6/6/2011)


    can you please send me some simple stored procedure for table alerts

    thankyou advance..

    What kind of Alert,can you give us more specification?

  • RE: Data storage structure

    My Default fill factor is 0,

    i am sorry that output from 32 bit sql server running on Window server 2008 32 bit edition in VMware.

  • RE: Data storage structure

    I think you have run that test on 32 bit system.i am working on 64 bit.

    I am getting same result you get on 32 bit system.i am able to insert...

  • RE: Data storage structure

    I have attached output of

    Exec sp_spaceused'ntinyint'

    DBCC IND ('SANDBOX','ntinyint',-1)

    in excel file.

  • RE: Data storage structure

    yes,that is true ,Page header size is 96 byte.when i insert 51 Row ,47 rows goes in first Data page and then Sql server insert remaining 4 row in second...

  • RE: problem about ' charachter when saving record.

    Run following code it will execute successfully

    declare @baslik nvarchar(max)=null

    SET @baslik='Izmir''in en güzel yerleri'

    Select @baslik

    while when you run following code you will get error

    declare @baslik nvarchar(max)=null

    SET @baslik='Izmir'in en güzel yerleri'

    Select @baslik

  • RE: problem about ' charachter when saving record.

    Yes,Cause ' character is used to start and end String.

    when you want to insert that value in sql sever,you must provide 'Izmir''in en güzel yerleri' to sql server.

    instead of 'Izmir'in...

  • RE: problem about ' charachter when saving record.

    sa.ordekci (6/5/2011)


    this works ok. problem is that ' character. i use fckeditor. If i use this dinamic insert query ' character gives error. how can i solve this problem?

    I...

  • RE: unable to count the occurance of column values..

    here you goes.

    SELECT COUNT(HardDisk) ,

    HardDisk

    FROM product

    GROUP BY HardDisk

    HAVING COUNT(HardDisk) >= 2

  • RE: Restore database error.

    SKYBVI (5/30/2011)


    not much on the server as its newly build ...it has

    Microsoft dynamics Great Plains

    SQL server 2005

    Acronis true image server and

    symantec endpoint protection

    Yes, im connected to right server for...

  • RE: Restore database error.

    SKYBVI (5/30/2011)


    When iam restoring via this query :-

    RESTORE DATABASE RTW

    FROM DISK = '\\servername\SQLBACKUP\RTW\RTW_backup_201105292015.bak'

    WITH MOVE 'GPSRTWDat.mdf' TO 'E:\MSSQL\Data\RTW.mdf',

    MOVE 'GPSRTWLog.ldf' TO 'E:\MSSQL\Data\RTW.ldf',

    STATS=5

    It does 30% and then throws this ERROR:--

    30 percent processed.

    Msg 3203,...

  • RE: Help with CASE statement

    GBeezy (5/30/2011)


    I have:

    SELECT *

    FROM tablename

    WHERE AccountID = '000001'

    This returns a blank value as that AccountID does not exist in the table. But, instead of returning nothing, I need it...

  • RE: what is the main difference between transaction log and backup the tale log backup

    dastagiri16 (5/30/2011)


    hi,

    could you plz clarify

    1.Main difference between transaction log and backup the tale log backup.

    2.I take backupe tail log backup my database is in restore mode how can i...

  • RE: Database refuses to auto-increment?? SQL Server Management Studio Express

    talismc (5/29/2011)


    GilaMonster (5/29/2011)


    Table definition (the create table statement) and the insert statement please

    Here, I wrote a statement to create a new table to see if it would work but I...

  • RE: Back up restore question

    Digs (5/28/2011)


    What steps should I restore a .bak file with REPLACE selected.

    you can following TSql Command to Restore Database with TSql Command.

    USE master

    RESTORE DATABASE Sandbox--YourDatabaseName

    FROM DISK='D:\SQL SERVER\Lab\Backup\Backup_20110529_0903_Full.bak'--your backupFile Path.

    WITH REPLACE

Viewing 15 posts - 16 through 30 (of 42 total)