Forum Replies Created

Viewing 15 posts - 1 through 15 (of 29 total)

  • RE: SA versus DBA

    Just to make it more fun, we have a third level.

    As a development team own our database servers (Dev and Prod) and have admin rights on them. On the servers,...

  • RE: BCP across systems

    This link http://support.microsoft.com/kb/248241 might be useful. You could possible then copy bcp across as well and it might run on your non SQL Server.

  • RE: Database Activty

    When we were trying to find out whether a database was still being used a while ago, not having been able to contact the owner of it, we reached the...

  • RE: (Very Urgent) SP Takes time & TSQL Statements Runs fast in Query Analyzer

    We suddenly got caught out by this last year. Having had a Stored Procedure in production for best part of a year, usually running in a few seconds, it started...

  • RE: latin1 character in column names

    You could try changing the datatype to nvarchar and the insert statement to

    insert into [testtable] values (1, N'test')

     

  • RE: Managing Sql 2000 with VS.NET 2003

    Check out Microsoft KB article 326613. It tells you which DLLs from SQL Server to package up into an MSI for distribution.

     

  • RE: Question of the Day for 17 Nov 2005

    Hmmm. Sneaky!

    I was sure of my answer in this (The table is created as dbo.MySecond and the grant and select complete successfully), as I am in the same situation. I...

  • RE: Automate Trigger Generation

    After a lot of fiddling, I found the answer myself:

    It appears that a String Variable starts to have odd behaviour during lots of concatenation operations once it gets past 4096...

  • RE: How much log is full

    This stored procedure goes slightly further by enabling a program to query the log space used easily:

    CREATE PROCEDURE dbo.DBO_LogSpace

    as

    declare @x int

                

    set nocount on

    if exists (select *...

  • RE: Introduction to SQL-DMO

    Again, a very useful article.

    One thing which may be of use:

    If you use WScript.Echo in aVBS file, then when the script is run by double clicking, then you get a...

  • RE: Need a RELIABLE table-exist test

    Using Enterprise Manager (or whatever), script a table to file. This gives something like:

    if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[your_table_name]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

    BEGIN

        --Your code...

  • RE: Starting to hate ASP.NET....pls help

    Some suggestions:

    1) Check to see if the reader has any rows:

          if userData.HasRows then

    2) Perform a specific conversion

          data_User_ID = userData.GetInt32(0)

    I generally get my data using...

  • RE: Full Path to Database

    You need to add a linked server reference (sp_addlinkedserver), possibly with a login (sp_addlinkedserverlogin) when you are not using Windows Authentication.

    Then reference the remote database using:

    server.database.schema.object.

    When querying a remote SQL...

  • RE: Weekend Task needs to run without users logged in

    That's a bit brutal; just kicking them out without any warning is a little unfair and not going to do much for your popularity.

    I have a system which runs a...

  • RE: Is all code really code? One question from an interview

    Hmmm. All very well, but as a developer, I don't have access to luxuries such as debugging and tracing / profiling. Our DBAs just don't allow it.

    At a push, they will run...

Viewing 15 posts - 1 through 15 (of 29 total)