Don't check the tables. Check the properties of the login you're using.

On the server you're linking to, use SETUSER as that login, and see if you can access the...

Does the linked server use a login with the right permissions on that table? Hopefully, you're not using sa in your linked server connection (the Security tab will tell...

I generally use a proc in the master database, set to run on startup, that will restart the trace. Use a dynamic name based on the date and time,...

For Zip codes (which are actually a USPS trademark), yeah, 5-digits is fine. Well, unless you need Zip+4. Of course, you can put the +4 in a separate,...

sqldba_newbie (10/30/2012)

---

GSquared (10/30/2012)

---

I'm not clear on what you're asking for help on. I see the code, I see you want to do something in a Join statement instead of...

sp_who2 should tell you which SPIDs are active in tempdb. Can use the Management Studio activity monitor (right-click the server name in the object explorer if you haven't use...

I'm not clear on what you're asking for help on. I see the code, I see you want to do something in a Join statement instead of "at the...

menon.satyen (10/30/2012)

---

Hi,

You can create a SSIS package using BIDS.

1. Create two data flow tasks

2. Data flow Task 1 will have OLE DB source, Data converter and excel destination(For groupA)

3....

Probably because, at the time the constraint is fired, the updated value hasn't been committed yet, so there's only one row with the live data, committed, and thus it doesn't...

Keep in mind, "1D2" will return 1 from IsNumeric, but will get an error if you try to convert it to an Integer. That's just one example of how...

Try the code from this article: http://www.sqlservercentral.com/articles/Tally+Table/72993/

It's not a data flow transformation.

Query the distinct values in the column, using an SQL Script task, assigning the resultant dataset to a variable, as usual.

Then step through that using...

How about skipping the check constraint and using a Unique, Filtered index?

CREATE UNIQUE INDEX UFI_NPIOrgAddressAvailability_NPIID_Default4Scheduling ON dbo.NPIOrgAddressAvailability (NPIID)

WHERE Default4Scheduling = 1;

Name the index per your local policy, of course. ...

webtekkie (10/30/2012)

---

Eugene - I didn't even notice your post earlier as I was posting at the same time. It's an excellent solution but sadly fails for the same reason...

There is an IsNumeric() function in T-SQL, but it's not very reliable.

I find a Where clause like this more useful:

WHERE MyColumn NOT LIKE '%[^0-9]%'

The ^ operator in a Like comparison...