Hi, I am not an experienced guy in SQL Server. Please help me to solve my problem. I can connect through Static connection to SQL Server without any problem. Eg, Enterprise Manager or Power Builder etc. But when I connect through Query Analyzer or ODBC I getting the following error. ODBC: Msg 0, Level 16, […]
2005-01-06
1 reads
I swear that I picked the answer without the 'false' parameter; but the answer page is telling me that I picked it. Has anyone else experienced this behavior? .... or has the DBA stress finally overcome me?
2005-01-05
Hi, Happy New Year There are two very basic options. The first is to generate a DTS package that performs all the tasks you need, alternatively, you could split the tasks into smaller DTS packages and schedule them as ‘Jobs’ (under management folder (if using 2000)). In both options you have a precedence order so […]
2005-01-05
From reading your post it looks like you want to know guests who will be in the hotel for at least one day between 8/1/05 and 8/10/05. It also looks like it doesn't matter when they will be checking out. Try the following query:Select <ColumnList> From <Table> Where ArrDate Between '08/01/05' and '08/10/05'
2005-01-04
Really the quickest way?Detach the db, rename or delete the log, attach the DB or useBACKUP LOG WITH TRUNCATE_ONLYDBCC SHRINKFILEBtw, changing the recovery mode has not much to do with the growth of the log file. In doing so, you give up your ability to restore to the point of failure or a point in time.
2004-12-29
I am very aware of the need, not just in Srilnka, but in all the countries that were hit. I must question your legitimacy, if you are true, then you have my prayers. Anyone who wishes to help would do better to donate to the local, national Red Cross (http://www.redcross.org/), or whatever relief organization exists […]
2004-12-29
Just a note though.I don't think that approach is legal, you have to OWN a copy of the full SQL product to use EM etc against MSDE. Or whatever the new, less confusing name is.
2004-12-28
Why do you want to do this? What are the requirements? Here is a fun "Select" SELECT DatePart(s, Getdate()), DatePart(s, Getdate()) + 1, GetDate(), DateAdd(s, 1, GetDate())
2004-12-27
1 reads
Ever thought of encrypting that sensitive data? That won't stop someone with sa privileges from watching the data, but he will not understand what he sees.
2004-12-16
...oh, I see. Well, no wonder, I didn't understand. This acronym isn't usual here in Germany
2004-12-16
Are you ready to take your SQL skills from theoretical to tactical? If you've...
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers