Forum Replies Created

Viewing 15 posts - 6,331 through 6,345 (of 13,460 total)

  • RE: How to get rid off it?

    Charmer (11/29/2011)

    ...SQL didn't let me do to create or alter or drop a table...

    that's kind of vague; did you get an error due to permissions, because you didn't have priviledges,...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 29, 2011 at 6:50 am

    #1414027

  • RE: how to create a GUID for the following case !!

    example of what? an insert with newid? the way i would do it?

    you'll need to provide a lot more details, i think..what table DDL do you have so far? what...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 28, 2011 at 6:25 pm

    #1413724

  • RE: how to create a GUID for the following case !!

    the newid() function and the datatype uniqueidentifier for the column data type is what you are looking for;

    you can make it the default value of a table, but...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 28, 2011 at 6:18 pm

    #1413722

  • RE: placing groups horizontally

    OK i've played with something similar..i wanted to orgianize data for a web page into 5 columns, instead of one increadabily tall column of data for a web page.

    here's...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 28, 2011 at 11:22 am

    #1413578

  • RE: Determining what objects, columns, tables are accessed with a query

    i'm not an expert in xml(yet), but i fiddled with this before:

    I'm assuming you mean you have an NVARCHAR dynamic SQL thing going on?

    this is getting all the plans in...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 28, 2011 at 11:00 am

    #1413568

  • RE: Bug in SQL MultiScript of RedGate

    waseem.shahzad 45937 (11/28/2011)

    The most likely reason for Multi-Script to skip a server is because it can't connect to that server

    not server... A DB on Same server.

    yep...seems to go back to...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 28, 2011 at 7:43 am

    #1413448

  • RE: Bug in SQL MultiScript of RedGate

    You'll probably want to show us the specific proc you get the error with.

    you also want to show the specific error you get.

    anyway, since it is an error in...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 28, 2011 at 7:03 am

    #1413407

  • RE: Bug in SQL MultiScript of RedGate

    is the specific syntax error possible version related? something that would be fine in, say Version 90 or above(2005+) but not in SQL 2000? could it be somethign as simple...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 28, 2011 at 5:33 am

    #1413368

  • RE: substring with charindex --Invalid length parameter passed to the substring function. Or conversion failed when converting varchar value to int.

    the problem is the substring you are looking for does not exist in every field....you have to use a where statement or a case statement to filter them out. specifically,...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 28, 2011 at 4:44 am

    #1413348

  • RE: Difference in Size of SQL Server 2008 R2 backup on Local disk and on Remote Network Share

    could the backup job be writing additional backups to the same file? ( does the script feature WITH INIT or not)

    you might have a big 10 gig file with 10+...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 26, 2011 at 6:37 am

    #1413105

  • RE: New faster server much slower than old slow server?

    when upgrading to a higher version, you'll want to rebuild the indexes and update statistics.

    There are a lot of similar posts, where the upgraded server performs poorly until those two...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 26, 2011 at 6:09 am

    #1413104

  • RE: Where are my Triggers?

    Jack Corbett answered in another thread that prompted me to question my sanity.

    it's the wrong view, but i still cannot use sp_helptext on a server trigger?

    select * from sys.server_triggers

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 23, 2011 at 1:11 pm

    #1412449

  • RE: AUTO_CLOSE reverts to ON in db created by attaching .mdf

    Bill Hansen (11/23/2011)

    The AUTO_CLOSE option is a server option in the model database and not a setting of the database. You can update the setting on your local server with...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 23, 2011 at 12:00 pm

    #1412407

  • RE: AUTO_CLOSE reverts to ON in db created by attaching .mdf

    that's a feature of express; by default, a database is autoclose = true in order to conserve resources.

    since the setting is visible in master.sys.databases, and not INSIDE the database,...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 23, 2011 at 11:49 am

    #1412398

  • RE: Uniqueidentifier.

    not sure where your issue likes, i'm able to convert to a varchar(40) no problem:

    create table Example(id int identity(1,1) not null primary key,myUQ uniqueidentifier)

    GO

    insert into Example (myUQ) VALUES (newid())

    GO 10...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    November 23, 2011 at 11:05 am

    #1412373

Viewing 15 posts - 6,331 through 6,345 (of 13,460 total)