Viewing 15 posts - 211 through 225 (of 628 total)
Here is a Microsoft article that gives you some ideas.
http://msdn.microsoft.com/en-us/library/ms187445.aspx
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
April 5, 2011 at 1:51 pm
I thought it might be a permission issue at first but we are using windows autenticated and I am and admin so that should not really be an issue.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
March 30, 2011 at 1:31 pm
Ah well I suppose we could use a veiw but this seemed like a proper use for a synonym. Excel has a check box to show synonyms so it...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
March 30, 2011 at 7:31 am
The motivation comes from the overly generic names used by the thir party software. For example the table structure looks something like this.
Bi001
Bi002
Bi003
Now thoise tables are actually the account...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
March 30, 2011 at 7:07 am
No good reason other than just have not got around to testing it with the product on the server. This is a mission critical server so it takes alot...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
March 29, 2011 at 3:16 pm
If you are creating a report through SSIS I would recommend creating the report through SSRS and then setup a subsrciption for the report.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
March 29, 2011 at 7:49 am
Open the SQL Server configuration manager and right click on the agent and selct properties. In the properties window you will find the login informaiton. this is also...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
March 28, 2011 at 12:07 pm
I would say that the answer is yes the User group likely granted access to the Service account that SQL Server Agent starts on. you may not have to have...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
March 28, 2011 at 10:51 am
For anyone who is interested or looking into this we did the upgrade this weekend and the older client laptops where able to replicate with out any problem to the...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
March 28, 2011 at 10:02 am
In you first example you are lookin at all records in TableA as such if a records does not exist in TableB then a NULL is returned. In the...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
March 28, 2011 at 9:27 am
The following scripts would place the entire contents of the current errorlog into a temp table.
CREATE TABLE ##Errors1 (ERRORLOG varchar(8000),continuationRow varchar(5))
INSERT into ##Errors1
(ERRORLOG,continuationRow)
Exec master..xp_readerrorlog
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
March 28, 2011 at 9:22 am
I can not get to the file you uploaded as the site is blocked on my work network. Can you paste the SQL code that is used?
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
March 28, 2011 at 8:42 am
While there are much easier ways of doing this through enterprise manager in 2000 you can do this in TSQL using a combination of sysobjects and sysindexes. you would...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
March 25, 2011 at 2:53 pm
when you allow multiple values the values are stored and passed as a string pretty much no matter what you do. If you select 1,2,3 while each value may...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
March 25, 2011 at 1:59 pm
I am not entirley sure you can use an or in an IIF in that way. try removind the second clause and see if that takes care of the...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
March 25, 2011 at 12:46 pm
Viewing 15 posts - 211 through 225 (of 628 total)