Forum Replies Created

Viewing 15 posts - 9,961 through 9,975 (of 13,460 total)

  • RE: export from 2005 and import to 2000

    I looked at your datafile,a nd because some records will contain multiple CrLf,s you will have to use SSIS or BCP, as suggested above.

    on the SQL 2005 server, you will...

    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!

    February 18, 2010 at 6:17 am

    #1120853

  • RE: Server Audit Job

    http://www.sqlservercentral.com/search/?q=audit

    audit has way to many connotations...

    audit data changes? backups success/failures? diskspace?usernames and roles? login successes/failures? servers on a network and all their versions?

    tell us what you are wanting 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!

    February 17, 2010 at 7:49 pm

    #1120618

  • RE: UNC Path of filename

    ok i see what you are trying to do;

    in order for this to work, the acount that is running the services will need domain admin priviledges in order to browse...

    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!

    February 17, 2010 at 11:43 am

    #1120319

  • RE: UNC Path of filename

    from what i just read WNetGetUniversalName 2will give you the UNC path to a shared resorce, but not a local resource;

    i think you'd have to build that yourself, and could...

    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!

    February 17, 2010 at 11:16 am

    #1120299

  • RE: UNC Path of filename

    not sure how much help this really is;

    but i found it in two places

    by running "NET USE" in a command window, i get results that i could use with xp_cmdshell:

    Status...

    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!

    February 17, 2010 at 9:54 am

    #1120212

  • RE: SQL Server 2008 running 50% faster on desktop than server - what to look for?

    for the ziptestserver plan, the QueryPlan DegreeOfParallelism="1", but for the homecexecution plan, it's QueryPlan DegreeOfParallelism="0";

    it looks like the rest of the plan is exactly the same though;

    Jeff mentioned it...

    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!

    February 17, 2010 at 9:37 am

    #1120203

  • RE: resize .ldf file

    you cannot resize it to be smaller than it currently is...did you perform a shrink before trying to modify the size? that is the most likely issue.

    I think you'll need...

    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!

    February 17, 2010 at 7:44 am

    #1120092

  • RE: T-SQL Coding - What is the difference between SQL Server DDL and DML commands? Can you name some examples of each?

    Remi you've got to look at the recent posts; he's pasted about a dozen interview questions to the forums, instead of googling. Even changed his screen name once since this...

    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!

    February 17, 2010 at 6:58 am

    #1120052

  • RE: want to retrive the date based on the date for every three months

    It sounds like you want to calculate reminder dates with an interval of three months, for lets say a year into the future?

    you'll want to use a Calendar or Tally...

    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!

    February 17, 2010 at 6:13 am

    #1120001

  • RE: SQL Server 2008 running 50% faster on desktop than server - what to look for?

    i'd suggest updating statistics right away on the server...that can often slow down execution plans.

    another thing to consider is the time it takes to assemble the information and send it...

    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!

    February 16, 2010 at 9:29 am

    #1119337

  • RE: Question on IF EXISTS()

    kingscriber with exists(), it should bail out on the first match it finds; seems like it ends up scanning 14K items until it hits a match, so I'd think that...

    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!

    February 16, 2010 at 7:07 am

    #1119252

  • RE: Question on IF EXISTS()

    I was recently "schooled"(ie chastised..hehe) here on the differences of IF EXISTS.

    IF EXISTS (SELECT 1 FROM FilesView WHERE Element IS NOT NULL)

    or

    IF EXISTS (SELECT * FROM FilesView WHERE Element...

    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!

    February 15, 2010 at 7:37 pm

    #1119047

  • RE: Compact Edition & Windows 7 Problem

    Ed i think it has to do with the version you are installing; I think SQL Express and SQL Express with Advanced Services only let you connect to a SQL...

    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!

    February 15, 2010 at 7:30 pm

    #1119045

  • RE: export then import records whos fields contain crrlf

    Ed i don't know if this is much help, but in the past when i wanted to get a table that had a field which contained CrLf, i ended up...

    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!

    February 13, 2010 at 12:50 pm

    #1118483

  • RE: Data disappearing from tables mysteriously

    mwstewart did you find out what the problem was? are there any triggers, or did you find something else?

    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!

    February 12, 2010 at 11:21 am

    #1118177

Viewing 15 posts - 9,961 through 9,975 (of 13,460 total)