Viewing 15 posts - 451 through 465 (of 629 total)
Far as I know it is automatic ... SQL Server can be configured to give priority to Named Pipe or TCP/IP connections. If you disable Named Pipes, and the client...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 12, 2009 at 7:07 am
Heh his been IT for 20+ years 😛 SO I call him old-timer LOL .. his just stuck in his ways :). We good buddies he actually listens; but...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 12, 2009 at 7:01 am
Any development platform really ...
Web apps (.asp, .net, etc.)
Desktop (.net, vb, java, access)
What are you trying to do?
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 12, 2009 at 6:37 am
1 - When Restoring a SQL 2000 .BAK file to SQL 2008, is there a best practise regarding such things? Should the database be updated in anyway? or just put...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 12, 2009 at 6:35 am
Try ...
SELECT FirstName, LastName, (SELECT TOP 1 BadgeID from Tabe2 AS T2 Where T2.PersonID = PersonID Order by validfrom desc) AS BadageID
FROM Table1
... Fixing small mistake on edit.
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 12, 2009 at 6:24 am
Hi,
Does you VB application use DSN? It is possible to configure those to use Named Pipes instead of TCP. SQL Server will communicate over either...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 12, 2009 at 6:22 am
Same as, Link.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 12, 2009 at 6:15 am
Something like this?
[font="Courier New"]CREATE TABLE #Temp (Col1 DATETIME, Col2 DATETIME)
INSERT INTO #Temp VALUES ('0:10:00', '3:15:00')
INSERT INTO #Temp VALUES ('0:10:00', '0:15:00')
INSERT INTO #Temp VALUES ('0:10:00', '1:15:00')
SELECT CONVERT(VARCHAR(8),Col1,108) AS StartTime,
CONVERT(VARCHAR(8),Col2,108)...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 12, 2009 at 6:07 am
To add to Michel ...
doing a delete from \\192.183.1.19\e$ is not good idea.
Instead i would create a new share and point it to the folder where you have...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 12, 2009 at 5:59 am
I think these system db (master, msdb, model, and resourcedb) are all pre-packaged by Microsoft so they don't get created from scratch. The model db is used as a...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 12, 2009 at 5:56 am
Good luck 🙂 And thanks for the update :D.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 12, 2009 at 5:43 am
Hi,
I just got chance to look at these plans .. All were with the last part of the query because of the parameters passed in:
1) You need to...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 12, 2009 at 5:39 am
Question is this SQL Server 2005? If it is running as your self fast but as developer maybe you are having issue with USERTSTORE_TOENPERM.
Check out: http://support.microsoft.com/kb/933564.
When you run it...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 12, 2009 at 4:47 am
SELECT * .. should have created a shared lock on the table; not an exlusive one if you find the answer please let us know :pinch:. But even shared...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 12, 2009 at 4:35 am
Since you are using 64-bit; awe settting does not apply to you. Now since I know that I strongly recommend you change it LOL. I seen a 64bit...
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
March 11, 2009 at 7:18 pm
Viewing 15 posts - 451 through 465 (of 629 total)