Forum Replies Created

Viewing 15 posts - 1,636 through 1,650 (of 13,460 total)

  • RE: Access a Database Without Linked Server

    so you had cross database queries,and because of the migration, one of the databases is now on another server?

    if i have that right, i think you can create an empty...

    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!

    July 16, 2015 at 1:37 pm

    #1813121

  • RE: Stored Procedure error when changing compatibility mode to 90 (2005)

    i encountered that same error way back when i upgraded.

    the error message is pretty clear.

    if you post the statement we can show you a lot better, but basically , as...

    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!

    July 16, 2015 at 12:57 pm

    #1813111

  • RE: Script to list replicated views and function

    it looks to me like only sys.tables and sys.views have the is_replicated column you are looking for.

    select object_name(object_id) from sys.all_columns where name ='is_replicated'

    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!

    July 13, 2015 at 9:51 am

    #1812054

  • RE: Script to list replicated views and function

    use sys.objects instead of sys.views, and use a filter on type_desc column; WHERE type_desc IN('VIEW','ETC....)

    SELECT DISTINCT type_desc FROM sys.objects

    select which types you want to use.

    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!

    July 13, 2015 at 9:24 am

    #1812034

  • RE: Challenge - dynamically load any file

    Abhijit More (7/13/2015)

    thxs Lowell the only concern I have in my files it may or may not have headers as well some file has Row Delimiter "CR LF"" and some...

    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!

    July 13, 2015 at 6:59 am

    #1811944

  • RE: Challenge - dynamically load any file

    lol Jeff that's evil;

    i could do it with Excel Automation in a script task, but all the columns would end up being "column1" "column2" because the first row does not...

    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!

    July 13, 2015 at 5:56 am

    #1811928

  • RE: Challenge - dynamically load any file

    Phil Parkin (7/13/2015)

    Good stuff. Importing everything as a string makes the task a lot easier, but what do you do about column length?

    i iternate through the datatable and 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!

    July 13, 2015 at 5:42 am

    #1811924

  • RE: Challenge - dynamically load any file

    i've done this with a script task, but i assume the file always has a header row for the column names, and that i know the delimiters, ie, comma/CrLf, tab/CrLf...

    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!

    July 13, 2015 at 5:32 am

    #1811920

  • RE: Before SSMS...Server 7

    in SQL7/SQL2000, the Builtin\Administrators group automatically inherits sysadmin in sql instances ont he same server, so if you are in the local administators group on server, you have sysadmin, andn...

    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!

    July 11, 2015 at 9:53 am

    #1811811

  • RE: Before SSMS...Server 7

    i still have one sql 2000 legacy machine, and i can connect ot it via SSMS, but the original SQL200 installation had two tools, "Enterprise Manager" and "Query Analyzer"

    SSMS combines...

    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!

    July 11, 2015 at 7:57 am

    #1811802

  • RE: How to Get Random Numbers

    a quick bump on an old post. i just needed to generate some random strings, and had this saved in my snippets. when i tested it, it didn't work,...

    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!

    July 10, 2015 at 12:19 pm

    #1811723

  • RE: How to find out from which client connection(computer name) or login id , SQL login got locked

    take a look at the SQL error log; the default for a normal installation is to log failed logins, so you can browse it with SSMS, and find the ip...

    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!

    July 10, 2015 at 9:19 am

    #1811649

  • RE: SQLCMD DBCC checkdb output file with date stamp

    Ray check out this script from my friend Gianluca Sartori; he's posted it several times here on SSC;

    he basically takes advantage of how DBCC supports WITH TABLERESULTS, and stuffs 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!

    July 8, 2015 at 11:24 am

    #1811067

  • RE: robocopy and named instances

    i also use robocopy to copy files out to an additional network location; i like the fact that it is smart enough to only move files that changed.

    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!

    July 8, 2015 at 8:43 am

    #1810986

  • RE: expanding the keyword AS

    for that, where the column name is dynamic, i think you have to switch to dynamic SQL, wher eyou build a commadn and execute it instead.

    a rough example:

    DECLARE @cmd...

    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!

    July 8, 2015 at 7:03 am

    #1810932

Viewing 15 posts - 1,636 through 1,650 (of 13,460 total)