Forum Replies Created

Viewing 10 posts - 31 through 40 (of 40 total)

  • RE: User prompt for data

    This might help

    @echo off

    CLS

    set /p UserName=User Name:

    set /p Institution =Institution:

    set Args=

    set Args= -q "SET NOCOUNT ON UPDATE USERACCOUNT SET USERPASSWORD = (SELECT 'ER' FROM USERACCOUNT WHERE USERNAME='%UserName%' AND INSTITUTION =...

  • RE: Migration SQL 2000 to SQL 2008 & Security

    also on scripting the logins sp_help_revlogin doesn’t scripted server roles

    Use the following query to script the server roles from prod, and executed in test bed .

    SELECT...

  • RE: Database Restore Never Finishes

    What is the error message u r getting ?

    How many files does the backup set has?

    Does the database has any secondary data files ?

    if possible give the screenshots

  • RE: comaptibility levels

    Run the SQL upgrade analyser and findout if any depriciated queries are used in ur 2000 database. If not change the cmpt level .

    If there was any,change the code...

  • RE: books to read about sql server performance

    Read articles from http://www.sql-server-performance.com/ ..It has all useful info on writing tuned queries.

  • RE: Who killed the process

    Thanks JeremyE .

    I did some search and got some info ..here s that

    The information about killed sessions was available on one of the undocumented DMV sys.dm_os_ring_buffers , with ring_buffers...

  • RE: How do i return dynamic t-SQL Steatement into a varibale

    sp_executesql will do

  • RE: Binary Files Import and Export

    sergey.benner , I tried with the single image file as you specified ,, still the image was correpted .. Is there some thing else we need to check ?

    Sample...

  • RE: Binary Files Import and Export

    CREATE TABLE files

    (

    --FileId INT IDENTITY(1,1),

    filepath varchar(512)

    )

    --I had my IMAGE file path in out.txt

    BULK INSERT dbo.files

    FROM 'D:\SQL\SQLWorkOut\out.txt'

    WITH

    (BATCHSIZE = 1,

    ROWTERMINATOR =''

    );

    select * from files

    CREATE TABLE bindata

    (data varbinary(max),

    fileid INT IDENTITY(1,1)

    )

    /*

    CREATE NONCLUSTERED...

  • RE: Binary Files Import and Export

    I tried the code by storing and retriving a Image File . Retival of new file by BCP command , the files are not meaning ful . Image does'nt displayed...

Viewing 10 posts - 31 through 40 (of 40 total)