MickyD (8/19/2014)

---

ScottPletcher (8/19/2014)

---

You should be able to get the spreadsheet into a table by right-clicking on the database to load it into, selecting "Tasks", then "Import Data...", and go thru...

You should be able to get the spreadsheet into a table by right-clicking on the database to load it into, selecting "Tasks", then "Import Data...", and go thru the wizard...

My preference would be this (the "extra" parentheses are important to properly match the requirements):

SELECT *

FROM YourTable

WHERE (SnapshotDate > @from AND SnapshotDate < @to)

OR (SnapshotDate = @from...

How many rows will be added / changed between uploads / syncs?

I suggest considering Change Tracking or some other automated method of determining changes rather than trying to do it...

The DBA's quite right, you need "WITH CHECK" explicitly specified (or allowed to default). I don't see an option in scripting to explicitly specify this (at least through 2008...

Grant Fritchey (8/16/2014)

---

ScottPletcher (8/15/2014)

---

What is(are) the clustering column(s) on the table? You need to read each 1/4 of the table at a time using the appropriate clustering key range.

What...

Shouldn't the event you want to intercept be "ALTER_DATABASE", not "RENAME"?

You'll need to interrogate the event data to identity a MODIFY NAME = vs other types of alter database commands.

What is(are) the clustering column(s) on the table? You need to read each 1/4 of the table at a time using the appropriate clustering key range.

What are there nonclustering...

AZ Pete (8/15/2014)

A unique constraint cannot be implemented since the combination of LocationId and ExternalId must be unique only for the cases when ExernalId is not null. There can be...

You should be able to create a DDL trigger to prevent database renames, at least through ALTER DATABASE. I hope sp_renamedb would get caught as well, but I haven't...

Alex R (8/15/2014)

this is the latest syntax error:

EXEC sde_Stage.dbo._aaa @table_name = ''GLOBAL'',@date = ''OBJECTIDLIST'',@reduce = 0.0025,@oid =''3476,6673''

SELECT * FROM OPENQUERY ([10.100.1.40], 'EXEC sde_Stage.dbo._aaa @table_name = ''GLOBAL'',@date = ''OBJECTIDLIST'',@reduce = 0.0025,@oid...

I don't believe you can use varchar(max) across linked servers; try varchar(8000).

Something like this:

SELECT ServerName

,SUM(CASE WHEN FileType <> 'LOG' THEN FreeSpace ELSE 0 END) AS 'Available Data Space'

,SUM(CASE WHEN FileType = 'LOG' THEN FreeSpace ELSE 0 END) AS 'Available...

You don't want quotes around the variable names, just the values, if they are not numeric:

SELECT * FROM OPENQUERY ([10.100.1.1], 'exec mydb.dbo.mysp @p1=''mytable'', @p2=0.0025,@p3 =''3476,6673,3321''')

That looks fine, unless you're trying to reference the return values, in which case you need to add an alias after the OPENQUERY(...) AS alias_name.