Forum Replies Created

Viewing 15 posts - 6,976 through 6,990 (of 13,460 total)

  • RE: how to run a sql from other servers without using linked servers

    don't forget Central Management Server is SSMS 2008...that allows you to run the same command on multiple servers.

    In the end, each server will require a connection in order to pass...

    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!

    August 9, 2011 at 5:51 am

    #1365799

  • RE: Frequently used DMV's & DBCC commands.....

    on the other hand, I know of DBA's who have never used the DMV's at all.

    Subjective Adapts covered the DBCC commands pretty well.

    I dunno, would you say that a...

    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!

    August 9, 2011 at 5:45 am

    #1365791

  • RE: String to binary

    you mean a binary representation/bitmap, i guess?

    i've got this saved in my snippets, but it's for 2005 and above because it's using a CTE.

    you might be able to adapt...

    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!

    August 9, 2011 at 5:36 am

    #1365782

  • RE: Read from Exchange Mailbox

    ok...but why via email? why not just have them go to a web page that generates a dataset, and presents the results, based on data input of those people 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!

    August 8, 2011 at 2:15 pm

    #1365512

  • RE: Export SQL table from one server to another

    bcp.exe OUT can export a table to a csv file, and then bcp.exe IN can import that file into the other server. you can use this method if the servers...

    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!

    August 8, 2011 at 1:20 pm

    #1365482

  • RE: Disk Space Full Drive:j: Percent:97.38%

    my first inclination is to see if there are any databases that are in FULL recovery mode, but have NEVER been backed up:

    they probably have gigabite sized log files and...

    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!

    August 8, 2011 at 1:08 pm

    #1365479

  • RE: Updating text valued(varchar) column with better performance

    6000 is pretty wide for a single username...is it a comma delimited list of names, or just an oversized column?

    if you do max(datalength(ThatColumn)), what's the largest current value?

    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!

    August 8, 2011 at 12:39 pm

    #1365462

  • RE: BCP command to import data from txt file (Pipe as Field terminator)into SQL Table.

    my bcp OUt exampel shows the delimiter between dbl quotes, and not the sole char after the -t.

    try that...

    also check your row terminator; if it's not CrLf, you might 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!

    August 8, 2011 at 12:02 pm

    #1365427

  • RE: I need Replace function in 2008 behaive like in 2005

    interesting...

    it looks to me that SQL 2008 has the REPLACE function overloaded now...pass it CHAR...it returns CHAR. pass it VARCHAR, it returns VARCHAR.

    maybe SQL 2005 didn't have the same overloaded...

    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!

    August 8, 2011 at 9:54 am

    #1365320

  • RE: Triggers or replication?

    Welcome aboard Jimmy;

    A few questions:

    Instance1 and Instance2 are seperate servers, right, and not databases?

    so the commands are really referencing ServerInstance1.LiveDatabase.dbo.Table1 and you want to migrate some data to OtherServerInstance.TestDatabase.dbo.Table1?

    Or are...

    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!

    August 8, 2011 at 9:25 am

    #1365295

  • RE: Execute Batch File Windows 2008/Sql 2005 - Error !!!

    Windows Task Scheduler.

    you can set a job to repeat on a schedule, but more importantly, you can decide what user context to run the command as much easier.

    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!

    August 8, 2011 at 9:11 am

    #1365285

  • RE: Execute Batch File Windows 2008/Sql 2005 - Error !!!

    Marcus has hit the core issue, i think: it's all about permissions, and the service running the SLq Service account doesn't have what is required.

    the fastest, easiest fix is...

    don't run...

    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!

    August 8, 2011 at 5:51 am

    #1365116

  • RE: How to find last updated row in the stored procedure

    unless your procedure is specifically updating a datetime column, or you have a ROWVERSION datatype as one of the columns in the table, it is not possible to determine the...

    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!

    August 8, 2011 at 5:43 am

    #1365112

  • RE: Abort SQL-Script with raiseerror

    i think you will also need to explicitly cast to a decimal; where are you getting the verison info from? how are you building the variable for the server version?

    ...

    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!

    August 8, 2011 at 5:41 am

    #1365111

  • RE: Create New Instance SQL Server database Engine

    an new instance is a complete installation, so you would have to run or re-run the MSI and explicitly give the name of the new instance...\SQL2005 or \SQLEXPRESS are commone...

    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!

    August 8, 2011 at 5:27 am

    #1365100

Viewing 15 posts - 6,976 through 6,990 (of 13,460 total)