chocthree (10/16/2016)

---

Hi all,

A newbie here wishing to ask for advice on Microsoft Business Intelligence. Hoping this is the right forum to put my questions.

I would like to learn Business Intelligence...

ismahmoud (10/13/2016)

---

i'm using this script :

select * into LinkedServer.[DB_Name].[dbo].[Table_Name] FROM Server2.[DB2_Name].[dbo].Table2_Name

but give this error:

Msg 117, Level 15, State 1, Line 1

The object name 'LinkerserverName.DB_Name.dbo.Table_Name' contains more than the maximum number...

mcfarlandparkway (10/10/2016)

---

I have two tables one is temporary and another is main dbo employee

In the main table I have added a column called fullamount. Basically this fullamount column is coming...

ok bulk has to references files ON THE SERVER or a fully qualified UNC path

so unless the SQL server is on your local machine, you need to move the...

Agreed. C:\Users\username\{anything} is...

all those packages are actually stored in an[image] data type in the [msdb].[dbo].[sysssispackages] table.

you could preview them or manually convert them to xml stringsand save them to disk.

select convert(nvarchar(max),convert(varbinary(max),packagedata)) from...

your Columns table would need the column name, data type+ size and probably whether it's null/not null;

defaults and foreign keys, even when coming from our definitions table would be...

Gmail, like many other client applications, have an option to prevent images from showing unless the sender is trusted. I had to do that...

based on experience, you won't find a one-function-to-rule-them-all address cleanup. break it up into smaller pieces that complement each other.

there's too many exceptions to the patterns;

what I've done previously is...

SQL-DBA-01 (9/26/2016)

---

Hi Experts,

Wanted to know if there is there any way to have database names aliases in SQL Server?

For example, there is a database with Name: "database A". Can...

there's a neat trick using FOR XML to get a delimited list of columns.

here's a snippet i wrote that i use in a procedure to generate sample insert/update/merge statements.

it assumes...

First, use Central Management Servers or Registered Servers; that will be where you add new servers as you discover them.

That functionality is built into SQL Server Management Studio, so there's...

Besides running the script with an impersonated credential, which solves the SQL problem,i would think you need an explicit path to your sql file:

sqlcmd -S myserver -E -i "C:\Data\AutomatedScripts\DeleteRecordsTest.sql"

for a large script, you'll want to execute it via sqlcmd instead of trying to open it in SSMS and executing it.

did you try selecting from the temp table, and left joining the larger table?

from your description, it sounds like your first table is the larger table, and you inner join...